Skip to content

Registered aircraft · 20,483

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N3340UGingerich Fred D · Heron, MTBuilt 1963 · S/N 18254740 N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340 N3341DTwenty One Miles LLC · Woodland Hills, CABuilt 1955 · S/N 32139 N3341FLani Lea Sky Tours LLC · Honolulu, HIBuilt 1966 · S/N 18257341 N3341RKozlenko Roman · Irvine, CABuilt 1967 · S/N 18258641 N3341UKroschel Wayne Addie · Mora, MNBuilt 1963 · S/N 18254741 N3342FKaradza Bosko S · Welch, MNS/N 18257342 N3342URobert Smith Associates Inc · Albany, NYBuilt 1963 · S/N 18254742 N3343FLutes Ralph E · Shipshewana, INBuilt 1966 · S/N 18257343 N3344RStorm Water Services Inc · Redmond, ORBuilt 1967 · S/N 18258644 N3344UPiescinski Kurt G · Fort Lauderdale, FLBuilt 1963 · S/N 18254744 N3345FBrassard Alan Gaston · Durham, NCBuilt 1966 · S/N 18257345 N3345RJennings Mamie M · Springfield, ILBuilt 1967 · S/N 18258645 N3345SSummit Foundry Systems Inc · Fort Wayne, INBuilt 1969 · S/N 21059145 N3346RGonzalez Oscar · Bedford, TXBuilt 1968 · S/N 18258646 N3346YVantrease Jerold L · Homer, AKBuilt 1962 · S/N 18254346 N3347FPrescott Aircraft & Automotive LLC · Prescott Valley, AZBuilt 1966 · S/N 18257347 N3347SArmitage Justin Marc · Hugoton, KSBuilt 1969 · S/N 21059147 N3347YMccoy Mark B · Honea Path, SCBuilt 1962 · S/N 18254347 N3348UCollins Christopher E · Bluford, ILBuilt 1963 · S/N 18254748 N3348YBlue Sky Flyers Inc · Punta Gorda, FLBuilt 1962 · S/N 18254348 N3349CCabrera John F · Glendale, CABuilt 1978 · S/N R18200274 N3349DWeninger Gregory M · Burrton, KSBuilt 1955 · S/N 32147 N3349FMaxfield David · Greenville, SCBuilt 1966 · S/N 18257349 N3349JRegistration Pending · Quincy, OHRegistration pendingS/N T18803632T N334SASchaumburg Flying Club Nfp · Palatine, ILBuilt 1998 · S/N 18280393 N334SCGist Sally R · Horseshoe Bay, TXBuilt 1960 · S/N 50691 N334WCenturion Investments Inc DBA · Chesterfield, MOBuilt 1976 · S/N U20603331 N334WDSouthwest Aviation Enterprises · Haslet, TXBuilt 2011 · S/N 20608334 N334YWarner Aric D · Rosamond, CAS/N 18051299 N3350FStrait Daniel · Sierra Vista, AZBuilt 1966 · S/N 18257350 N3350SBarry Jason J · Orange, CABuilt 1969 · S/N 21059150 N3350UKragseth Kyle A · Shoshone, IDBuilt 1963 · S/N 18254750 N3351STarantino Nicholas T Jr · Union City, CAS/N 21059151 N3352FDaradici Jodi A · Gilbert, AZBuilt 1966 · S/N 18257352 N3353UWieser Ranch Inc · Vernon, COBuilt 1963 · S/N 18254753 N3354YFelkins Roger C · Hillsboro, ALBuilt 1962 · S/N 18254354 N3355RSkyhawks Flying Club Inc · Canton, SDBuilt 1967 · S/N 18258655 N3356FShroyer Scott E · Peyton, COBuilt 1966 · S/N 18257356 N3356SBbt Inc · Wilmington, DEBuilt 1969 · S/N 21059156 N3357DHodel Lawrence E · Hayden, IDBuilt 1955 · S/N 32155 N3357URunway Ventures LLC · Salida, COBuilt 1963 · S/N 18254757 N3358RHaydukovich Steven J · Phoenix, AZBuilt 1967 · S/N 18258658 N3358UBratcher Michael · Elizabethtown, KYS/N 18254758 N3359FHughes John · Almira, WABuilt 1966 · S/N 18257359 N335SFRamont Ronald G Jr Trustee · Modesto, CABuilt 1977 · S/N 21062413 N3360FLane Glen Allen Jr · Cocoa, FLBuilt 1966 · S/N 18257360 N3360SMohler Earl C · Bonita, CAS/N 21059160 N3360UBailes Ernest J IV · Shepherd, TXBuilt 1963 · S/N 18254760 N3360YFoote Jerry O · Unadilla, NYFirst renewal noticeBuilt 1962 · S/N 18254360

Back to AD 84-10-01 R1