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.

N2457FPettyjohn Nancy Paulette Sautebien · Dearborn, MIBuilt 1973 · S/N A1500402 N2457RPicotte Paul C · Fallon, NVBuilt 1964 · S/N 18255557 N2458FErickson Timothy M · Mead, NEBuilt 1973 · S/N A1500403 N2458LBowman Joseph F · Flora, MSBuilt 1966 · S/N 17255658 N2458XMountain City Flying Club Inc · Hazle Township, PABuilt 1965 · S/N 18256358 N2459LMedia Stew LLC · Carson City, NVBuilt 1966 · S/N 17255659 N2459RGardiner Timothy M · Gardendale, ALBuilt 1964 · S/N 18255559 N2460JSmith Harry N · Glendale, AZBuilt 1966 · S/N 15065560 N2460XHardy Gareld L · Rimrock, AZS/N 18256360 N2461JWeidemann Wendell S · Madison, WIBuilt 1966 · S/N 15065561 N2461RFx Mining LLC · Haines, AKBuilt 1964 · S/N 18255561 N2461XBallard Devin J · Quail, TXBuilt 1965 · S/N 18256361 N2462JBercaw Vaughn L · Beach City, TXBuilt 1966 · S/N 15065562 N2462LSneed Associates LLC · Fort Morgan, COBuilt 1966 · S/N 17255662 N2463JTony Noyes · Lewisville, TXS/N 15065563 N2464RStoffers William · Samoa, CABuilt 1964 · S/N 18255564 N2465JWalther Nora P · Ocala, FLBuilt 1966 · S/N 15065565 N2465XK4 Land And Grain Co · Lothair, MTBuilt 1965 · S/N 18256365 N2466QWentworth Douglas G · Simpsonville, KYBuilt 1966 · S/N 18257666 N2466RToland Beldon T · Dodge City, KSBuilt 1964 · S/N 18255566 N2467JHenderson Samuel · Wasilla, AKS/N 15065567 N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667 N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567 N2468BRegistered aircraftBuilt 1970 · S/N 18260274 N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668 N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568 N2469MDillehay David Lynn · League City, TXBuilt 1973 · S/N 15075201 N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669 N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N246BCKeystone Solutions LLC · Higley, AZS/N 18259539 N246PAHugie Lucas R · Logan, UTS/N 18257487 N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670 N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670 N2471JKrisch Garry A · Kenedy, TXBuilt 1966 · S/N 15065571 N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671 N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571 N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672 N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N2473RRonald O Holcomb LLC · Lapeer, MIBuilt 1964 · S/N 18255573 N2474JSingleton Addison L · New Bedford, MABuilt 1966 · S/N 15065574 N2474QBurnet Aviation Group LLC · Bertram, TXBuilt 1966 · S/N 18257674 N2474XKramer William L · Wellington, FLBuilt 1965 · S/N 18256374 N2475QStumpf Walter · Tulsa, OKBuilt 1966 · S/N 18257675 N2475XJohnston Bruce W · Puyallup, WABuilt 1965 · S/N 18256375 N2476RBascom Richard J Trustee · Elkhart, IABuilt 1964 · S/N 18255576 N2477RJohnson Michael W · Kensington, OHBuilt 1964 · S/N 18255577 N2478QAbraham Curtis L · Byron, WYBuilt 1966 · S/N 18257678 N2478RWeber Alan M · Manteca, CABuilt 1964 · S/N 18255578

Back to AD 72-03-03 R3