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.

N3167FGreen James C · Cedar Rapids, IABuilt 1966 · S/N 18257267 N3167JRay Charlie B DBA Chucks Air Service · Prosser, WABuilt 1966 · S/N 15065867 N3167SLightning Bolt Aviation LLC · Bozeman, MTS/N 18255667 N3168RRunck Russell E · Watertown, MNBuilt 1967 · S/N 18258568 N3169TOwen James D · Fort Lauderdale, FLBuilt 1967 · S/N 17700469 N3169XVirgilio Domenico · Rochester Hills, MIBuilt 1966 · S/N 15064569 N316HYLakeview Aviation Inc · Newport, VTBuilt 1977 · S/N 17702651 N316LSC M & N D Inc · Wilmington, DEBuilt 1964 · S/N 18255604 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N316PCRegistration Pending · Payson, AZRegistration pendingBuilt 1968 · S/N 15069440 N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668 N3170JDobrzynski Andrzej J · Chicago, ILBuilt 1966 · S/N 15065870 N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170 N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570 N3170XFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 15064570 N3170YStillson John L · Rock Rapids, IAS/N 18254170 N3171FRockin Rt LLC · Smithfield, UTS/N 18257271 N3171JRay Charles B · Prosser, WAS/N 15065871 N3171TVanlandingham Michael E · Oxnard, CABuilt 1967 · S/N 17700471 N3171XJohnson Christopher A · San Diego, CABuilt 1966 · S/N 15064571 N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171 N3172FKuhn Joseph C · Manhattan Beach, CABuilt 1973 · S/N A1500407 N3172SSterling Flyers LLC · Lehi, UTS/N 18255672 N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172 N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273 N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673 N3173XRegistration Pending · Lutz, FLRegistration pendingBuilt 1966 · S/N 15064573 N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274 N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174 N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574 N3174XRenner Colton A · Easley, SCBuilt 1966 · S/N 15064574 N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275 N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875 N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575 N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175 N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876 N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576 N3176YThomas Steven Dale · Monticello, ILS/N 18254176 N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660 N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877 N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677 N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477 N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577 N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177 N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878 N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478 N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178 N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279 N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879 N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179

Back to AD 72-03-03 R3