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.

N7577GElkhorn Aviation Inc · Baker City, ORBuilt 1970 · S/N 17259277 N7577TRoot Franklin L · Staunton, VABuilt 1959 · S/N 47177 N7577XBlusky Aviation LLC · Palmyra, INBuilt 1960 · S/N 17248077 N75786Bienvenu Reuben S · Lafayette, LABuilt 1976 · S/N 17267948 N75788Hawk Air LLC · Parma, OHBuilt 1976 · S/N 17267949 N7578GThree Little Birds Inv LLC · Nashville, TNBuilt 1970 · S/N 17259278 N7578XHamilton Randel L · Quitaque, TXBuilt 1960 · S/N 17248078 N75790Kempton Larry G · Grand Junction, COBuilt 1976 · S/N 17267950 N75791D L S Aviation Services Inc · Wilmington, DEBuilt 1976 · S/N 17267951 N75793Miami Valley Career Technology Center · Clayton, OHBuilt 1976 · S/N 17267953 N75794Appleton Scott · Cunningham, TNFirst renewal noticeBuilt 1976 · S/N 17267954 N75795Harrison Mark A · Corpus Christi, TXS/N 17267955 N75797Eralet Inc · Middletown, DEBuilt 1976 · S/N 17267957 N75799Ocean Breeze Aviation Inc · Hollywood, FLBuilt 1976 · S/N 17267959 N757LELake Elmo Aero LLC · Lake Elmo, MNS/N 17266022 N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629 N757WKKuersteiner William C · Panacea, FLBuilt 1962 · S/N 17249290 N75801Hartland Aviation LLC · New Smyrna Beach, FLBuilt 1976 · S/N 17267960 N75803Kuntz Donald Alan · Whitefish, MTBuilt 1976 · S/N 17267962 N75805Roney Howard D · Salem, ORBuilt 1976 · S/N 17267964 N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965 N75807Pearl River Community College · Poplarville, MSS/N 17267966 N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967 N7580XSorgen Michael A · Corning, NYBuilt 1960 · S/N 17248080 N75816Lns Aviation LLC · Chandler, AZBuilt 1976 · S/N 17267973 N7581GManasco Inc · Tucson, AZBuilt 1970 · S/N 17259281 N75820Zoviv Michael · Hollywood, FLBuilt 1976 · S/N 17267977 N75822International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 17267979 N75823Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17267980 N75824Williams John S · Fort Walton Beach, FLBuilt 1976 · S/N 17267981 N75825Patrick Ronald D · Locust Grove, GAFirst renewal noticeBuilt 1976 · S/N 17267982 N75829Hofmann LLC · Blauvelt, NYBuilt 1976 · S/N 17267985 N7582GCapps Christopher T · Anchorage, AKBuilt 1970 · S/N 17259282 N7582TJones Todd R · Ozona, TXBuilt 1959 · S/N 47182 N7582XSemchenko Norval K · Max, NDBuilt 1960 · S/N 17248082 N75831Mccall Freddie W · Century, FLBuilt 1976 · S/N 17267987 N75833Blees James E · Anchorage, AKBuilt 1976 · S/N 17267989 N75837Linder Ronald G · Fort Wayne, INBuilt 1976 · S/N 17267992 N75838Fadel Shaheen J · Charlotte, NCS/N 17267993 N75839Rocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1976 · S/N 17267994 N7583GPebworth Properties LLC · Auburn, WABuilt 1970 · S/N 17259283 N7583XGreene Bryan V · Turlock, CABuilt 1960 · S/N 17248083 N75840Planebros LLC · Bixby, OKBuilt 1976 · S/N 17267995 N75842Foree John Baird · New Castle, KYBuilt 1976 · S/N 17267997 N75844Command Aviation Inc · Bellingham, WABuilt 1976 · S/N 17267998 N75845Stark Russell Allen · Madison, WIBuilt 1976 · S/N 17267999 N75846Rodgers Lynn C · Springfield, MOBuilt 1976 · S/N 17268000 N7585GCessna85g LLC · Manassas, VABuilt 1970 · S/N 17259285 N7585TBustamante Luis E · Longview, TXBuilt 1959 · S/N 47185 N75860Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 1976 · S/N 17268005

Back to AD 90-06-03 R1