Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N736VTRucker William C Trustee · Sanger, TXBuilt 1978 · S/N R18200778 N736WHB&B Island Aviation LLC · Sylvania, OHBuilt 1978 · S/N R18200779 N736WPN736wp LLC · Waterford, NYBuilt 1979 · S/N R18200781 N736WXStone Aviation LLC · Cusick, WABuilt 1978 · S/N R18200783 N736XGStonecipher Guy Austin III · Beaumont, TXBuilt 1978 · S/N R18200785 N736YLFive Star Electric Inc · Lakin, KSBuilt 1978 · S/N R18200789 N736YQZupanick Joseph A · Montevallo, ALBuilt 1978 · S/N R18200790 N736YWInvestments Property Holdings Aviation LLC · Jonesboro, GAS/N R18200793 N736YYYankee Yankee LLC · Bend, ORBuilt 1978 · S/N R18200795 N736YZHamilton Rial Pc · Austin, TXBuilt 1978 · S/N R18200796 N736ZDEllis Jack E Trustee · Tahoe City, CABuilt 1979 · S/N R18200797 N736ZGWhiskey Romeo 1 LLC · Jacksonville, FLS/N R18200800 N736ZJO'Connell Patrick J · Henderson, NVS/N R18200802 N736ZNTakemori Gil M · San Jose, CABuilt 1978 · S/N R18200805 N736ZPPaul Roussell LLC · Delhi, IABuilt 1978 · S/N R18200806 N736ZTAircraft Structural Repair Inc · Hamilton, MTBuilt 1978 · S/N R18200810 N736ZVBerry Andrew J · Saint Paul, MNBuilt 1979 · S/N R18200812 N736ZXRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N R18200813 N73702Shiles Darrel J · Baltimore, MDBuilt 1976 · S/N 17267615 N73707Leading Edge Flight Academy LLC · Bend, ORBuilt 1976 · S/N 17267620 N73719Purdue Aviation LLC · West Lafayette, INBuilt 1976 · S/N 17267624 N73726Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267630 N73728Crowe Robert B · Del Valle, TXBuilt 1976 · S/N 17267632 N73732Midway Capital Aviation Inc · Orlando, FLBuilt 1976 · S/N 17267634 N73734Daro Norman E · Cody, WYBuilt 1976 · S/N 17267636 N73735Martineau Aircraft Inc · Butte, MTBuilt 1976 · S/N 17267637 N73744Fca Flight Center Inc · Fitchburg, MABuilt 1976 · S/N 17267643 N7374DBig E LLC · Lemoore, CABuilt 1979 · S/N 17272918 N7374EWings As Eagles Mission Air Service Inc · Oshkosh, WIBuilt 1978 · S/N 17272098 N73753Stick And Rudder Club Inc · Waukegan, ILBuilt 1976 · S/N 17267652 N73754Weninger Mark J · Maize, KSBuilt 1976 · S/N 17267653 N73755Lima 001 LLC · Muscatine, IABuilt 1976 · S/N 17267654 N7375GAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1970 · S/N 17259075 N73761Spring City Aviation Inc · Waukesha, WIBuilt 1976 · S/N 17267658 N73764White David W · Woodland, WAS/N 17267661 N73768Flighttime Inc · Wiscasset, MEBuilt 1976 · S/N 17267664 N73769Canino Enterprises Inc · Miami, FLBuilt 1976 · S/N 17267665 N73776Seebold Jdustin K · Mifflinburg, PABuilt 1976 · S/N 17267670 N73784Dsr Cherokee 180 LLC · Dallas, TXBuilt 1976 · S/N 17267676 N73785Sierra Sky Aviation LLC · Whitefish, MTBuilt 1976 · S/N 17267677 N73786Wings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267678 N73787Pegasus Flying Club LLC · Mccordsville, INS/N 17267679 N73790Jimenez Carlos A · Davie, FLBuilt 1976 · S/N 17267682 N73798Lowry Steve · Sun River, MTBuilt 1976 · S/N 17267688 N73799Sojak Therin F · Harlingen, TXBuilt 1976 · S/N 17267689 N737AAHogan Thomas A · Fairfield, OHBuilt 1977 · S/N 17269258 N737ABBellingham Aviation Services LLC · Bellingham, WAS/N 17269259 N737ACU56fliers LLC · Idaho Falls, IDBuilt 1977 · S/N 17269260 N737ADDe Zafra Aaron · Mill Valley, CABuilt 2004 · S/N 941-2003 N737AEBluewater Airmotive Corp · Wilmington, DEBuilt 1977 · S/N 17269262

Back to AD 80-25-07 R1