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.

N4206QOsmonovich Michael · Kent, WABuilt 1971 · S/N 17260106 N42072Rempe Richard Henry · Bumpass, VABuilt 1968 · S/N 18258844 N42078Hellebuyck Ralph Charles Jr · Attica, MIBuilt 1968 · S/N 18258845 N4207LGlaude Jason T · Scarborough, MEBuilt 1966 · S/N 17254276 N42082Fmp Energy Inc · Bryan, TXBuilt 1968 · S/N 18258847 N4208LHowell Jerry C · Deatsville, ALBuilt 1966 · S/N 17254277 N4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIBuilt 1971 · S/N 17260109 N420PKSmoking Joes Terps Co · Wasilla, AKS/N U2060868 N420WWFlying Colors Airparts Inc · Leesburg, FLS/N 15069243 N42105H & J LLC · Naturl Br Sta, VABuilt 1968 · S/N 18258854 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N42118Walsh Air LLC · Live Oak, FLBuilt 1976 · S/N 177RG1088 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N42120Spiegel Darren J · Chicago, ILBuilt 1968 · S/N 18258861 N42124Wright Stephen A · St George, UTBuilt 1968 · S/N 18258864 N42131Massicott David P · Friendswood, TXBuilt 1968 · S/N 18258867 N42132Witt Lawrence · Solvang, CABuilt 1968 · S/N 18258868 N42134Wilmark Anesthesia Pllc · Corpus Christi, TXBuilt 1968 · S/N 18258870 N4213LBuenrostro Paul · Burney, CAS/N 17254282 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N42141Over The Top Aviation Inc · Jonesboro, ARBuilt 1968 · S/N 18258871 N42148Rizzo Michael R · Yorba Linda, CABuilt 1968 · S/N 18258874 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N42150Custom Air Solutions LLC · Broadway, VABuilt 1968 · S/N 18258875 N42151Foster Floyd W · Lyon, MSBuilt 1968 · S/N 18258876 N42154Datil Fly Inc · Saint Augustine, FLBuilt 1968 · S/N 18258878 N42159Cutruzzula Arthur · Pittsburgh, PABuilt 1968 · S/N 18258881 N42164Bush David W · Camden, NCBuilt 1968 · S/N 18258882 N4216LN4216l LLC · Kapolei, HIBuilt 1966 · S/N 17254285 N42175Roberts Jason L · Crossville, TNBuilt 1968 · S/N 18258885 N42176N42176 LLC · Lynn Haven, FLBuilt 1968 · S/N 18258886 N42177Skydive Baltimore LLC · Churchville, MDBuilt 1968 · S/N 18258887 N42184Designed Cabinets · Lakeville, MNBuilt 1968 · S/N 18258890 N42188Verge Gregory J · Lynnwood, WABuilt 1968 · S/N 18258891 N4218LWengs Enterprises Inc · Tustin, CABuilt 1966 · S/N 17254287 N4218QSavant John D · Kinder, LAS/N 17260118 N42198Johnson Steve · Belen, NMBuilt 1968 · S/N 18258894 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N42202Palmer Charles L · Huntington Beach, CAFirst renewal noticeBuilt 1968 · S/N 18258895 N42204Conservation Aviation LLC · Washington, DCBuilt 1968 · S/N 18258897 N42206Jones Brian William · Portland, ORBuilt 1968 · S/N 18258899 N42209Smith Patrick G · Wenatchee, WABuilt 1968 · S/N 18258901 N4220LDelordzia Mark · Columbia, NJBuilt 1966 · S/N 17254289 N42219Beck Daniel Joseph · Tuscaloosa, ALBuilt 1968 · S/N 18258908 N4221LSchram Ted K · Mukwonago, WIBuilt 1966 · S/N 17254290 N4221QRegistered aircraftBuilt 1971 · S/N 17260121 N4222LRtd Aviation LLC · Hillsborough, NJS/N 17254291 N4222QBearlodge Spray Foam & Coatings LLC · Sundance, WYS/N 17260122 N42232Wheater Eric Alexander · King George, VABuilt 1968 · S/N 18258914 N42234Vp Niagara Aviation LLC · Niagara Falls, NYS/N 18258916

Back to AD 72-03-03 R3