Skip to content

Registered aircraft · 40,395

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930 N38311Archair Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 28-7790538 N38313Lwr LLC · Teton, IDBuilt 1977 · S/N 28-7725262 N38315Meyer Lynn O · Olathe, KSBuilt 1977 · S/N 28-7725275 N38316Meriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7716241 N38319Fronduto Cody Michael · Fort Pierce, FLBuilt 1977 · S/N 28-7790539 N3831PPerkins Jason T · Hudson, MEBuilt 1955 · S/N 22-3521 N3831ZFloats N Hoes LLC · Umatilla, FLBuilt 1961 · S/N 18-7574 N38324De Oliveira Antonio J · Fuquay Varina, NCBuilt 1977 · S/N 28-7790535 N3832ZHoward Gary O · Eagle, AKBuilt 1961 · S/N 18-7575 N38333Sonex Aircraft LLC · Oshkosh, WIBuilt 1941 · S/N 6943 N3833QDowning Robert · Talent, ORBuilt 1971 · S/N 17259933 N3833ZDominguez Carlos L · Gainesville, GABuilt 1961 · S/N 18-7576 N3834RK J Aviation LLC · Jasper, INBuilt 1970 · S/N 28-5828 N3835VJones Scott L · Hilliard, OHBuilt 1957 · S/N 18693 N3836KValarchi Air Aviation LLC · Lewes, DEBuilt 1967 · S/N 28-23743 N3836ZTroutman Charles W · Lincoln City, ORBuilt 1960 · S/N 18-7588 N38373Outbound Aviation LLC · Dover, DEBuilt 1977 · S/N 28-7716247 N3837PPlancich Don A · Sterling, AKS/N 14-154 N3837QBaja Guided Tripps LLC · Grand Lake Stream, MEBuilt 1971 · S/N 17259937 N3837ZTroutman Charles Wayne · Lincoln City, ORBuilt 1960 · S/N 18-7589 N3838PArlins Aircraft Service Inc · Belgrade, MTBuilt 1955 · S/N 22-3528 N3838ZWoldow Fredric A · Morton, ILBuilt 1960 · S/N 18-7592 N38394Wall Jeffrey L · Goffstown, NHBuilt 1977 · S/N 28-7790548 N3839LFlight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N ME-397 N3839PMorris Equipment LLC · Yuma, AZBuilt 1955 · S/N 22-3529 N3839ZPrax Philip G · Fairbanks, AKFirst renewal noticeBuilt 1961 · S/N 18-7593 N383BHAero Aircraft 13 LLC · Jacksonville, FLBuilt 1974 · S/N 17264151 N383CCWiplinger Charles · Inver Grove, MNBuilt 2001 · S/N 9938CC N383DFDream Flight LLC · Westminster, MDBuilt 1977 · S/N 17269914 N383HRJirak Daniel L · Wasilla, AKBuilt 1985 · S/N 001 N38409Straub Craig W · San Martin, CABuilt 1977 · S/N 28-7790255 N3840PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1955 · S/N 22-3530 N3840ZWorley Donald E Jr · Rocky Mount, VAS/N 18-7594 N38411N38411 LLC · Bellevue, WABuilt 1977 · S/N 28-7790356 N38412Rekaa Enterprises LLC · Paragould, ARBuilt 1977 · S/N 28-7716251 N3841TN3841t Lk Aircraft Holdings LLC · Wheeling, ILBuilt 1981 · S/N M-2307 N3841ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1961 · S/N 18-7595 N38421Sale Reported · Ephrata, WASale reported, pending cancellationBuilt 1977 · S/N 28-7790551 N3842PJohnson Carroll J · Tok, AKS/N 22-3532 N3842VN3842v LLC · Wainscott, NYBuilt 1973 · S/N 17262158 N3842ZWilliams Sunita L · Houston, TXBuilt 1961 · S/N 18-7596 N38433Global Aviation Corp · Farmingdale, NYBuilt 1977 · S/N 28-7716254 N3844KSymonds Gregory S · Old Lyme, CTBuilt 1967 · S/N 28-23746 N3844QSmtm Holdings Inc · Wilmington, DEBuilt 1971 · S/N 17259944 N3845QMacon Flying Club Inc · Macon, MOBuilt 1971 · S/N 17259945 N3845ZWilcox Mark A · Mccook, NEBuilt 1961 · S/N 18-7600 N38477California In Nice Inc · San Jose, CABuilt 1977 · S/N 28-7725282 N38478Pa28 LLC · Sebastian, FLBuilt 1977 · S/N 28-7725283 N3847PRegistered aircraftBuilt 1955 · S/N 22-3538

Back to AD 79-10-03 R2