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.

N522DRIbrahim Tarek M · Lawrenceville, VABuilt 1966 · S/N 15063327 N522FN522f LLC · Titusville, FLBuilt 1970 · S/N 17258510 N522KSkyhigh Aviation Investments Inc · Daytona Beach, FLBuilt 1974 · S/N 15075544 N522XSkyfest Aviation Investments Inc · Daytona Beach, FLBuilt 1964 · S/N 17252411 N5230UAllen Etienne · Simi Valley, CABuilt 1964 · S/N 206-0230 N5231QMonti David G · Middleport, NYBuilt 1965 · S/N 17253288 N5232FGilbert Christopher J · Edmonds, WABuilt 1965 · S/N 17253291 N5232UScruggs Kenneth R · Galloway, OHBuilt 1964 · S/N 206-0232 N5233UKenai Gravel Products LLC · Salt Lake City, UTFirst renewal noticeBuilt 1964 · S/N 206-0233 N5234FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253297 N5234ZZieg R Daniel · Marathon, FLBuilt 1968 · S/N 17257122 N5235FUnited States Air Force · March Afb, CABuilt 1965 · S/N 17253301 N5235QPoules Alexander · Hope Valley, RIBuilt 1972 · S/N 15073135 N5236QPeters Terry M · Okeechobee, FLBuilt 1972 · S/N 15073136 N5237FGreer James F · Louisville, KYBuilt 1965 · S/N 17253308 N5237QKretschmer Bryan · Hawthorne, NJBuilt 1972 · S/N 15073137 N5238QMolek Jon · Warren, OHBuilt 1972 · S/N 15073138 N5239FDanner Charles L Sr · Oak Harbor, OHBuilt 1965 · S/N 17253314 N5239QWayland Johnny R · Stephenville, TXS/N 15073139 N5240QRamesh Manohari D · Liberty Township, OHBuilt 1972 · S/N 15073140 N5241FUnited States Air Force Owner · Apo, APBuilt 1965 · S/N 17253322 N5242QShimata Kenneth S · Honolulu, HIBuilt 1972 · S/N 15073142 N5244URoberts Todd · Friday Harbor, WABuilt 1964 · S/N 206-0244 N5245XPlane Fixer LLC · Ball Ground, GABuilt 1968 · S/N 18258856 N52465Clutter Mark R · Spencer, OHS/N 177RG1195 N52476Good Guys Flying Club LLC · Colorado Springs, COBuilt 1977 · S/N 177RG1197 N5247QCavu Pilot LLC · Powell, TNS/N 15073147 N52489Cardinal Club Llp · Fargo, NDBuilt 1977 · S/N 177RG1198 N5248QSmith Gary A · Ericson, NEBuilt 1972 · S/N 15073148 N52493Lasky Matthew T · Constable, NYBuilt 1977 · S/N 177RG1199 N52497Hobar Geoffrey · Hoffman Estates, ILBuilt 1977 · S/N 177RG1201 N5249F3 Mad Wives Aviation LLC · Claremont, MNBuilt 1965 · S/N 17253346 N5249QLarson Loren R · Omro, WIBuilt 1972 · S/N 15073149 N524BLDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 21058477 N524MESmith Lester C Jr · Colleyville, TXS/N 17258149 N5250QLegan Matthew · Franklin, INBuilt 1972 · S/N 15073150 N5251UDavid Vanderpol Construction Co · Harrison, SDS/N 206-0251 N52543Berry Curtis L · Williamsport, MDBuilt 1977 · S/N 177RG1206 N5255FHirsch Jeffrey D · Lutherville, MDS/N 15073155 N5255KReighley Robert G · Xenia, OHBuilt 1967 · S/N 18258124 N52578Wall Leslie A Trustee · Stevensville, MDBuilt 1977 · S/N 177RG1207 N52579Urquhart David L · Winchendon, MABuilt 1977 · S/N 177RG1208 N52582Wheeler Kevin K · Thornville, OHS/N 177RG1209 N52585Colley Reid W · Pauls Valley, OKS/N 177RG1210 N52589Audritsh John E DBA · Indianapolis, INBuilt 1977 · S/N 177RG1211 N5259QFrantz David L · Murfreesboro, TNBuilt 1972 · S/N 15073159 N525DBMurtagh Aaron Thomas · RuislipS/N 0484 N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549 N525XHarvey Thomas H · Novi, MIBuilt 1963 · S/N 206-0013 N52604Harding Marc S · Des Moines, IABuilt 1977 · S/N 177RG1213

Back to AD 72-03-03 R3