Skip to content

Registered aircraft · 2,052

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

N100CAFass Flyers LLC · Garden Ridge, TXBuilt 1978 · S/N 18266536 N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264 N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562 N104JSSmith Timothy A · Shafter, CABuilt 1977 · S/N 18265625 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N107SPDepartment Of Emergency Svc & Public Protection · Hartford, CTBuilt 1984 · S/N 18268427 N1080MFlying Particles Inc · Livermore, CABuilt 1977 · S/N 18266034 N10948Morris Jacky D · Watonga, OKBuilt 1977 · S/N 18266102 N11182Smith Brian · Roanoke, TXBuilt 1979 · S/N 18266815 N111SRPayne John A · Bloomington, ILBuilt 1981 · S/N 18268005 N112DSCarter Erick D · Eugene, ORBuilt 1977 · S/N 18265826 N1136GBurnside Thomas L · Kansas, ILBuilt 1978 · S/N 18266300 N113HBSnyder Shad J · Quincy, WABuilt 1983 · S/N 18268318 N114CZMinnesota Department Of Public Safety · Saint Paul, MNBuilt 1981 · S/N 18267892 N116AHRegistered aircraftBuilt 1981 · S/N 18267966 N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579 N116SUBoolean Flight Sciences LLC · Mercer Island, WAS/N 18266668 N117PHR & R Leasing LLC · Fargo, NDBuilt 1977 · S/N 18265492 N117TTMustang LLC · Wilsonville, ORBuilt 1978 · S/N 18266432 N118HRDieschbourg Thomas Arthur · Glenview, ILBuilt 1983 · S/N 18268332 N118SCLeathers Charles M · Silverthorne, COBuilt 1981 · S/N 18268069 N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086 N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498 N121MTc-Craft Aero Club Inc · Nampa, IDBuilt 1977 · S/N 18265624 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122TGAnzalone Donald Michael · Durango, COBuilt 1980 · S/N 18267533 N122WTStoimenov Kirill H · San Andreas, CABuilt 1977 · S/N 18266094 N123KLWings Over The Rockies LLC · Wittmann, AZBuilt 1977 · S/N 18265746 N125PBEvergreen Financial Investments LLC · Wayzata, MNBuilt 1977 · S/N 18265348 N126JCGebler Laurence W · Ellerbe, NCBuilt 1979 · S/N 18267134 N127ETThomas Eric C · Boise, IDBuilt 1982 · S/N 18268234 N127TJRegistration Pending · Bowersville, GARegistration pendingBuilt 1978 · S/N 18266629 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N12KMFitzmaurice Productions Inc · Fawnskin, CABuilt 1977 · S/N 18265774 N12LRBalk Martin · Warren, NJBuilt 1978 · S/N 18266528 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N1323EHu Zhehua · Sunnyvale, CAS/N 18268174 N1354ESandra And Mose Rucker III LLC · Perrineville, NJBuilt 1982 · S/N 18268175 N136STScull Timber Co Inc · Tenaha, TXBuilt 1978 · S/N 18266476 N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176 N138SWQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 18265569 N13DSR & M Adventures LLC · Wichita, KSBuilt 1980 · S/N 18267798 N141WBElevated Dreams Aviation LLC · Huntington, NYBuilt 1976 · S/N 18265249 N1420EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268177 N1432ENorrisky Consulting LLC · Bozeman, MTBuilt 1982 · S/N 18268178 N143CPPonzo Christopher A · North Reading, MABuilt 1980 · S/N 18267699 N143KMBc Aircraft LLC · Edmonds, WABuilt 1977 · S/N 18265435 N1440ECreighton Mark · Port Aransas, TXBuilt 1982 · S/N 18268179 N146EN146e LLC · Thomasville, GABuilt 1982 · S/N 18268292

Back to AD 2009-04-05