Skip to content

Registered aircraft · 17,028

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.

N8580GRhoat William E · Paso Robles, CAFirst renewal noticeBuilt 1965 · S/N 15062680 N8580UBaker Shane A · Marshall, WIBuilt 1965 · S/N 17252480 N8581SBlack Samuel W · Kennesaw, GABuilt 1965 · S/N 18256681 N8581ULarkin John · Cambridge, IDBuilt 1965 · S/N 17252481 N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482 N8582UMartin Livestock LLC · Ione, CABuilt 1965 · S/N 17252482 N8583SDevillier Roland James · Winnie, TXBuilt 1965 · S/N 18256683 N8583UVon Burg Jon B · Hull, ILS/N 17252483 N8584JDarrach Todd I · Rhome, TXBuilt 1967 · S/N 15066484 N8584SRider Richard Trustee · Mill Valley, CABuilt 1965 · S/N 18256684 N8584UPlane View Portraits LLC · Wolverine Lake, MIBuilt 1966 · S/N 18257756 N8584VIdk Ventures LLC · Olympia, WABuilt 1965 · S/N 17252484 N8585GCollins Terry R · Lewistown, ILBuilt 1965 · S/N 15062685 N8585SPreszler Terry J · Richland, WABuilt 1965 · S/N 18256685 N8585UTreats Aviation Inc · Enumclaw, WABuilt 1965 · S/N 17252485 N8587JMorgan Jeffrey E · Peebles, OHBuilt 1967 · S/N 15066487 N8587U172 Blue Wings LLC · Berwyn, PABuilt 1965 · S/N 17252487 N8588GTulsa Technology Center School Dist No 18 · Tulsa, OKBuilt 1965 · S/N 15062688 N8588JLyons Donald F · Cheverly, MDFirst renewal noticeBuilt 1967 · S/N 15066488 N8588UNachio Aviation Services LLC · Tucson, AZS/N 17252488 N8589GRay Clinton R · Brighton, MIBuilt 1965 · S/N 15062689 N8590GAsher Charles S · Grosse Ile, MIBuilt 1965 · S/N 15062690 N8591SRivera Carlos A · Beach Park, ILBuilt 1965 · S/N 18256691 N8592UJls Construction & Mining Inc · Flagstaff, AZS/N 17252492 N8595GLazy 8 Flying Service LLC · Polson, MTBuilt 1965 · S/N 15062695 N8595UMoore James F Jr · Alexandria, KYS/N 17252495 N8596JNelson David D · Mercer, PABuilt 1966 · S/N 15066496 N8596UAtlanta Air Academy LLC · Kennesaw, GABuilt 1965 · S/N 17252496 N8597UMrd Aero LLC · Manheim, PABuilt 1965 · S/N 17252497 N8598SBradley Christopher J · Left Hand, WVBuilt 1965 · S/N 18256698 N8598UMcclay Andrew · Baker City, ORBuilt 1965 · S/N 17252498 N8599GBoatright Michael L · Live Oak, FLBuilt 1966 · S/N 15062699 N8599SMcclung Malcolm J · Ripon, WIBuilt 1966 · S/N 18256699 N85JWWhittington Robert W · Blackwell, OKBuilt 1968 · S/N 17257686 N85NEvans Thomas P · Hollow Rock, TNBuilt 1966 · S/N 18257256 N85SSCornelius John W · Elgin, TXBuilt 1966 · S/N 15064568 N8600GHunter Brian D · Scranton, IAFirst renewal noticeBuilt 1965 · S/N 15062700 N8600ZChamberlin Aviation · East Wenatchee, WABuilt 1967 · S/N P206-0400 N8601GRamakrishna Murali DBA · Burlington, MABuilt 1966 · S/N 15062701 N8601SDykstra Wayne A · Pipestone, MNS/N 15061901 N8601UKing Stephen M · Trout Lake, WABuilt 1965 · S/N 17252501 N8601ZMagnolia Springs Properties Inc · Kirbyville, TXS/N P206-0401 N8602UAllegood Jerry C · Moultrie, GABuilt 1965 · S/N 17252502 N8604JPouncey Wayne · Merced, CAFirst renewal noticeBuilt 1967 · S/N 15066504 N8604UMurray Stephen A · Worthington, OHBuilt 1965 · S/N 17252504 N8604ZHirsch T J Jr · Olney, TXBuilt 1967 · S/N P206-0404 N8605GPhelps John W · Spring Hill, FLBuilt 1965 · S/N 15062705 N8605UTurner Scott K · Wichita Falls, TXBuilt 1965 · S/N 17252505 N8606JMaedgen Gary W · Voss, TXS/N 15066506 N8606SFlight Time Builders Inc · Memphis, TNBuilt 1965 · S/N 15061906

Back to AD 72-03-03 R3