Skip to content

Registered aircraft · 20,687

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N79050Batto Jeannie L · Madison, INBuilt 1969 · S/N 17257843 N79052Rose Gary A · Brighton, TNBuilt 1968 · S/N 17257844 N79054N18228 Inc · Williamsburg, VABuilt 1969 · S/N 17257846 N79055Amies John W · Zimmerman, MNBuilt 1968 · S/N 17257847 N79057First Eclipse Limited · Richmond, VABuilt 1968 · S/N 17257849 N7905UAutrey Howard T · Freeport, TXBuilt 1964 · S/N 17251905 N79060K&L Aviation LLC · Prosper, TXBuilt 1968 · S/N 17257851 N79062Pierce Brenden D · Eatonville, WAS/N 17257853 N79063Sprague Todd K · Placerville, CABuilt 1968 · S/N 17257854 N79065Kingston Thomas P · Carmel, INBuilt 1968 · S/N 17257856 N79066Doran Vincent J Jr · Wasilla, AKBuilt 1968 · S/N 17257857 N79068Padgett Leonard Dale · Hobart, OKBuilt 1968 · S/N 17257858 N7906XNewton Ashlynne S · Yuma, COS/N 17248406 N79071Cottrell Mark C · Leitchfield, KYBuilt 1968 · S/N 17257860 N79072Registered aircraftBuilt 1968 · S/N 17257861 N79079Jones Farm Fresh LLC · Bartlett, TNBuilt 1968 · S/N 17257867 N7907UReifenberger Robert A · Saint Petersburg, FLBuilt 1964 · S/N 17251907 N79081James Ferrick · Mechanicville, NYBuilt 1968 · S/N 17257869 N79086Marshall County Flying Club Inc · Lacon, ILBuilt 1968 · S/N 17257870 N79087Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 17257871 N79089Ramaswamy Gautam · Clearwater, FLBuilt 1968 · S/N 17257872 N7908BFrancis James E · King City, CABuilt 1957 · S/N 29708 N7908GChamberlain Bruce H · Worcester, MABuilt 1970 · S/N 17259608 N7908UBrogan Scott D · Bellevue, OHBuilt 1964 · S/N 17251908 N79090Caughman John R · Katy, TXBuilt 1968 · S/N 17257873 N79092Aero Quest LLC DBA · Olive Branch, MSBuilt 1968 · S/N 17257874 N79093Bray Austin M · Pontotoc, MSBuilt 1968 · S/N 17257875 N79095Hole In The Clouds Rentals LLC · Montgomery, ALBuilt 1969 · S/N 17257877 N7909GCopass Kaneia · Fountain Run, KYBuilt 1971 · S/N 17259609 N7909XEisenhauer Lyle M · Sterling, NEBuilt 1961 · S/N 17248409 N790FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13169 N790SPMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8716 N79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHBuilt 1969 · S/N 17257882 N79104Roman Nose Flying Club Inc · Newalla, OKBuilt 1969 · S/N 17257884 N79105Linn Nicholas D · Norfolk, NEBuilt 1969 · S/N 17257885 N7910BJohnson John A Trustee · Sandy, ORBuilt 1957 · S/N 29710 N7910GBrusse Leslie W · Enterprise, ALBuilt 1970 · S/N 17259610 N7910UStechschulte Jason P · Fort Jennings, OHBuilt 1964 · S/N 17251910 N79113Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17257889 N79118Osceola Aerosport LLC · Osceola, WIBuilt 1969 · S/N 17257893 N79119Carr Randal J · Chandler, OKBuilt 1969 · S/N 17257894 N7911BDaugherty Monte R · Anderson, INBuilt 1957 · S/N 29711 N7911XRice David L · Dickson, TNBuilt 1961 · S/N 17248411 N79122Johnson John C · Squaw Valley, CABuilt 1969 · S/N 17257896 N79125Brekhus Palmer A · Tolley, NDBuilt 1969 · S/N 17257897 N79126Grounded Hangar Inc · Turlock, CABuilt 1969 · S/N 17257898 N7912USweet Breeze Aviation LLC · Gordonsville, VABuilt 1964 · S/N 17251912 N7912XWang Jinrao · Riverdale, GABuilt 1961 · S/N 17248412 N79130M&M Shipshape LLC · Kalispell, MTBuilt 1969 · S/N 17257901 N79133Rotate LLC · Eden Prairie, MNBuilt 1969 · S/N 17257903

Back to AD 90-06-03 R1