Skip to content

Registered aircraft · 17,027

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

N7321GTriad Aviation Academy LLC · Greensboro, NCS/N 17259021 N7322GHolt Thomas H · Griffin, GAS/N 15074647 N7323GSpiker Jeffrey A · Granville, OHBuilt 1970 · S/N 17259023 N7325CPollard Seka A · Huntington, WVBuilt 1965 · S/N 18256400 N7328GShort Larry D DBA · Allen, KYBuilt 1970 · S/N 17259028 N7329GFive Guys Aviation LLC · Pendleton, SCBuilt 1970 · S/N 17259029 N7334GEllis Gregory D · Winnsboro, TXBuilt 1970 · S/N 17259034 N7335GJordan Jeffrey B · Woodland, WABuilt 1970 · S/N 17259035 N7337GReiss Alan T · Puyallup, WABuilt 1970 · S/N 17259037 N7341GHolmes Omer Lane Jr · Metairie, LABuilt 1970 · S/N 17259041 N7345GJacks Air Service Inc · Greenville, MEBuilt 1970 · S/N 17259045 N7346GBentley Darrell Howard · Powell, TNBuilt 1970 · S/N 17259046 N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047 N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048 N734CWilliams Jimmy D · Goodwell, OKBuilt 1967 · S/N 18258134 N734SGRydalch Carl D · Saint Anthony, IDBuilt 1965 · S/N 18256270 N7350GFox Victor Aviation LLC · Newnan, GABuilt 1970 · S/N 17259050 N7351GMiddlebury Flying Club Inc · Middlebury, VTBuilt 1970 · S/N 17259051 N7353GWoodliff Alexander Harrison · Truesdale, MOS/N 17259053 N7354GRight Rudder LLC · Rexburg, IDFirst renewal noticeBuilt 1970 · S/N 17259054 N7355GAerolanding LLC · Enterprise, ALBuilt 1970 · S/N 17259055 N7356GHolcomb John R · Siloam Springs, ARBuilt 1970 · S/N 17259056 N7357FLittle Bird Airways LLC · Hamburg, NYS/N 15066920 N7358GN7358g Inc · Las Vegas, NVBuilt 1970 · S/N 17259058 N7362GKeno Leasing LLC · Monroe, LABuilt 1970 · S/N 17259062 N7363GFlying High Again LLC · Mount Juliet, TNS/N 17259063 N7365GPray Aviation Inc · Augusta, KSS/N 17259065 N736LBSkyraider Aero Club · Spokane, WABuilt 1972 · S/N 17701825 N7372GSky Cops LLC · Midland, TXBuilt 1973 · S/N 15074651 N7375GAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1970 · S/N 17259075 N737KPPhill-Air Inc · Dover, DEBuilt 1968 · S/N 15067475 N737WPAeroworks Productions LLC · Kenosha, WIBuilt 1970 · S/N 177RG0032 N7380GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259080 N7386GCrosswind Flyers Inc · Newton, NJBuilt 1970 · S/N 17259086 N7387GSale Reported · Redondo Beach, CASale reportedBuilt 1970 · S/N 17259087 N7393GBlue Wings LLC · Brecksville, OHBuilt 1970 · S/N 17259093 N7395GBrewer James · Myakka City, FLBuilt 1970 · S/N 17259095 N7397GMarkowitz Edwin P · Luray, VABuilt 1970 · S/N 17259097 N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559 N73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidBuilt 1966 · S/N 15064948 N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809 N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833 N73SC73sc Owners Group Inc · Torrance, CABuilt 1965 · S/N 18256623 N73TFKlanchar Flying LLC · Benton, ARBuilt 1966 · S/N 17255638 N7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLBuilt 1970 · S/N 17259105 N7407GStarr Ralph H · Port Orange, FLBuilt 1973 · S/N 15074654 N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109 N74150Meyer Tabatha M · Fairview, TXBuilt 1973 · S/N 15074538 N7415KClarke Kenneth J · Anchorage, AKS/N 17259115 N7416GDreggors David Richard · Altamonte Springs, FLBuilt 1970 · S/N 17259116

Back to AD 72-03-03 R3