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.

N784DJAlta Volare LLC · Wilmington, DEBuilt 1968 · S/N 21059104 N7850GWhitfield Robert O Jr · Hurdle Mills, NCS/N 17259550 N7850UJohnson Lawrence F · Sacramento, CABuilt 1964 · S/N 17251850 N78512United States Air Force Academy Aero Club · Usaf Academy, COBuilt 1969 · S/N 17257646 N78513Reeder Gary T · Galena, OHBuilt 1968 · S/N 17257647 N78515Becker Jarrod L · Selfridge, NDBuilt 1968 · S/N 17257648 N78517Johnson Kevin R · Gladstone, ORBuilt 1968 · S/N 17257650 N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951 N7851UR & S Aviation LLC · Corning, ARBuilt 1964 · S/N 17251851 N78520Jdb Aviation Inc · Merritt Island, FLBuilt 1968 · S/N 17257651 N78523Sunderman Randy · Norfolk, NEBuilt 1968 · S/N 17257653 N78525Aero II Inc · Spartanburg, SCBuilt 1969 · S/N 17257655 N78526Miklus Michael III · Saint Georges, DEBuilt 1968 · S/N 17257656 N7852UMartinson James C · Sioux Falls, SDBuilt 1964 · S/N 17251852 N78531Goodridge Flying Club Inc · Goodridge, MNBuilt 1968 · S/N 17257658 N78538Drover Michael A · Winter, WIBuilt 1968 · S/N 17257660 N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953 N78542Tolmachev Nikolay A · Anchorage, AKBuilt 1968 · S/N 17257661 N78548Bakalar Flying Club Inc · Columbus, INBuilt 1968 · S/N 17257662 N7854GNeuschaefer George H · White Hills, AZBuilt 1970 · S/N 17259554 N78553Shop Branch Equipment Co Inc · Marble Falls, TXBuilt 1968 · S/N 17257666 N7855FSmith Joshua B · Kenai, AKS/N 15063955 N7855GAlpenglow Air 3 LLC · Anchorage, AKBuilt 1970 · S/N 17259555 N7856FFitzgibbon Patrick D · Waterloo, WIBuilt 1966 · S/N 15063956 N7856GMitchell Lindsey T · Chesnee, SCBuilt 1970 · S/N 17259556 N78579Hamilton George D · Bandera, TXBuilt 1968 · S/N 17257673 N7857GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259557 N7857UMok Kuch · Delano, CABuilt 1964 · S/N 17251857 N7858FShelley Tiffany · Chandler, AZFirst renewal noticeS/N 15063958 N78590Obrien Connor J · Mulino, ORBuilt 1968 · S/N 17257676 N78596Oshea Thomas F · Hamilton, NJBuilt 1968 · S/N 17257678 N78598Schaefer Joseph P · Weyerhaeuser, WIS/N 17257680 N7859GAviators LLC · Casco, WIBuilt 1970 · S/N 17259559 N7859UDuncan Martin R · Newark, ARBuilt 1964 · S/N 17251859 N78603Beaufort Flight Training LLC · Beaufort, SCBuilt 1968 · S/N 17257682 N78606Brook Trout Properties LLC DBA · Kalamazoo, MIBuilt 1968 · S/N 17257684 N7860FVahary David J · Portage, INBuilt 1966 · S/N 15063960 N7860GRoberts Timothy J Jr · Taylor, TXBuilt 1970 · S/N 17259560 N7861FFranks Bryan S · Camarillo, CABuilt 1966 · S/N 15063961 N7861GHamilton William D · Lynnwood, WABuilt 1970 · S/N 17259561 N7861U150 Flyers · Ithaca, MIBuilt 1964 · S/N 17251861 N78622Copeland David Craig Aka · Jackson, GABuilt 1968 · S/N 17257689 N78623Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1968 · S/N 17257690 N78624Dewing Matthew S · Rome, PABuilt 1968 · S/N 17257691 N78626Ycm Solutions Inc · Mechanicsville, VABuilt 1968 · S/N 17257693 N78628Milot John M · Germansville, PABuilt 1968 · S/N 17257694 N7862GBogue Rodney J · Warner Robins, GABuilt 1970 · S/N 17259562 N7863UNoldin Gregory Paul · Griffith, INBuilt 1964 · S/N 17251863 N78640Glasheen Sean T · Bethel, AKS/N 17257698 N78642Little Falls Pilots Assn Inc · Nisswa, MNBuilt 1968 · S/N 17257699

Back to AD 72-03-03 R3