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.

N70915Patterson Thomas L · Bryan, TXBuilt 1968 · S/N 18259417 N70917Edwards Guy A · Sedalia, COBuilt 1968 · S/N 18259419 N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791 N7091SMoyer Alan L · Perkasie, PABuilt 1967 · S/N 15067791 N70920Lannoye Tyler G · Leeds, NDBuilt 1968 · S/N 18259420 N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792 N70933Beta Flight LLC · South Burlington, VTS/N 18259423 N70938Dawson Ranch Aviation LLC · Encinal, TXBuilt 1968 · S/N 18259425 N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693 N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793 N70949Saucier Brock D · Dallas, TXBuilt 1968 · S/N 18259431 N7094FLarsen Gary A · Honolulu, HIBuilt 1966 · S/N 15063694 N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794 N7094QRegistered aircraftBuilt 1972 · S/N 17260394 N7094SEdwards Thomas · West Richland, WABuilt 1967 · S/N 15067794 N70956Holdsworth Randy L · Zoar, OHBuilt 1968 · S/N 18259435 N70958Froh Samuel · North Pole, AKS/N 15074631 N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795 N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395 N7095SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 15067795 N70966Kelly David M · Hedgesville, WVS/N 18259437 N70967Bramblett Steve · Bennington, OKBuilt 1968 · S/N 18259438 N7096FJanuary Lynn E · Mcpherson, KSFirst renewal noticeBuilt 1966 · S/N 15063696 N70974Ross Donald Malcolm · Lawton, OKBuilt 1968 · S/N 18259439 N70977Soran Patrick David · Reno, NVBuilt 1968 · S/N 18259440 N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797 N70981Broken Rainbow Enterprises Inc · Torrey, UTBuilt 1968 · S/N 18259443 N70984Rau Brian C · Medina, NDBuilt 1968 · S/N 18259445 N70986Hobby John J · Durango, COBuilt 1968 · S/N 18259446 N70987Sutherland Jason · Auburn, WAS/N 18259268 N70988Kelley Ronald C · Deer Lodge, MTBuilt 1968 · S/N 18259448 N7098FBumps Stephen D · Gilead, MEBuilt 1966 · S/N 15063698 N7099FMiles Del R · Blackfoot, IDBuilt 1966 · S/N 15063699 N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799 N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399 N709LCN709lc LLC · Orange, TXBuilt 1966 · S/N 15063937 N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629 N709RHHope Ronald F · Clemmons, NCBuilt 1970 · S/N 18260387 N70CWHeartland Travel LLC · Columbia, MOBuilt 1965 · S/N P206-0168 N70DKParmley Terry R · Michigan City, INBuilt 1963 · S/N 17255493 N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954 N70VHBlue Sky Flyers LLC · Fairfield, NJBuilt 1971 · S/N 18260765 N70WBGraves Lucas M · Santa Rosa, CABuilt 1967 · S/N 18257978 N70WHOrtega Ricky J · Amarillo, TXBuilt 1965 · S/N 18256010 N71002Sheepdog Aviation LLC · Murfreesboro, TNBuilt 1968 · S/N 18259454 N710061 Lowflyer Inc · Harrisonville, MOBuilt 1968 · S/N 18259455 N71007Farmer Gary E · Saint Augustine, FLBuilt 1968 · S/N 18259456 N71009Fairhurst George D II · Kailua, HIFirst renewal noticeS/N 18259457 N7100GBoyd John J · Wasilla, AKBuilt 1969 · S/N 17258800 N71016Fiesbeck Kirt E · Saint Joseph, MIBuilt 1968 · S/N 18259459

Back to AD 72-03-03 R3