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.

N75538Mike Moser Inc · Wilmington, DEBuilt 1976 · S/N 17267793 N7553BTri Star Aviation Inc · Nashua, NHBuilt 1977 · S/N A1520767 N7553EPolley Terri J · San Antonio Height, CAFirst renewal noticeBuilt 1978 · S/N 17272106 N75548Mcfadden Edward C · Ferris, TXBuilt 1976 · S/N 17267798 N75549Matthews Raymond H Jr · Rhoadesville, VABuilt 1976 · S/N 17267799 N7554FJohnson Michael L · Jefferson, TXS/N 206-70 N7554VOlson Nicholas W · Copper Canyon, TXBuilt 1976 · S/N 177RG0850 N75555American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267804 N75559Gillanders Robert Ross Personal Representative · Gig Harbor, WABuilt 1976 · S/N 17267808 N7555GSac Air LLC · Citrus Heights, CABuilt 1970 · S/N 17259255 N7555VWallen Bruce R · New Britain, CTBuilt 1976 · S/N 177RG0851 N75560Nexga Aircraft Inc · Greensboro, NCS/N 17267809 N75565Flight 915 LLC · El Paso, TXS/N 17267814 N75566Wilson Robert J · Annville, PABuilt 1976 · S/N 17267815 N7556FWetzel Gehred · Factoryville, PABuilt 1969 · S/N 732-70 N7556GWetlesen Gabriel C · Palmer, AKBuilt 1970 · S/N 17259256 N7556VWennerstrom Kirk · Norwalk, CTBuilt 1976 · S/N 177RG0852 N75571Kohls Bruce P · Melbourne, KYBuilt 1976 · S/N 17267817 N75572Bean Keith Owen · Glenwood, IABuilt 1976 · S/N 17267818 N75575Mayo William J Jr · Reed Point, MTBuilt 1976 · S/N 17267820 N7557GLe Gros Donald P · Jennings, LABuilt 1970 · S/N 17259257 N7557TArizona Flyers Club Inc · Tucson, AZBuilt 1977 · S/N R18200038 N7557VTexas Dentco LLC · El Paso, TXBuilt 1976 · S/N 177RG0853 N7557XWright Aero Inc · Saint Cloud, MNBuilt 1977 · S/N R18200099 N75586Adventist World Aviation · Wilson, NCBuilt 1976 · S/N 17267829 N75587Ullah Muhammad K · Federalsburg, MDBuilt 1976 · S/N 17267830 N75588Emry Scott D · Brookings, ORBuilt 1976 · S/N 17267831 N7558FSchaller Lee · New Athens, ILBuilt 1969 · S/N 226-70 N7558GKessler Garry A · Lansing, WVS/N 17259258 N7558LBahinting Dan Brian M · Rosamond, CABuilt 1978 · S/N A1520819 N7558VSisk James G · Coppell, TXFirst renewal noticeBuilt 1976 · S/N 177RG0854 N75590Burgess Wayne R · Brown City, MIBuilt 1976 · S/N 17267832 N75591Reynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17267833 N75596Christian Charles R · La Crescenta, CABuilt 1976 · S/N 17267837 N75598Columbia Jet Center Inc · Columbia, MOBuilt 1976 · S/N 17267839 N7559FDodge Donald V · Newnan, GAS/N 208-70 N7559GLopez Johnny · Henderson, NVBuilt 1970 · S/N 17259259 N7559KSkyway II LLC · Naples, FLS/N P21000410 N7559VNorton Lyle K · Coquille, ORBuilt 1976 · S/N 177RG0855 N755CMCluster Fish LLC · Charleston, SCBuilt 1980 · S/N 21063934 N755MCCisneros Joe M · Nashville, TNBuilt 1983 · S/N R18201959 N755PR101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267405 N75600Airspeed Marketing LLC · Phoenix, AZFirst renewal noticeBuilt 1976 · S/N 17267840 N75601Sierra Corp · Worthngtn Spg, FLBuilt 1976 · S/N 17267841 N75602Jkg LLC · Murfreesboro, TNBuilt 1976 · S/N 17267842 N75603Riexinger Keith D · Ellensburg, WAFirst renewal noticeBuilt 1976 · S/N 17267843 N75605Miller Mark · Atascadero, CABuilt 1977 · S/N 17267845 N75608Albertson Michael D · Greenwood, SCBuilt 1976 · S/N 17267847 N7560DJiang Jun · Fremont, CABuilt 1979 · S/N 17272922 N7560FCitabria Club LLC · Baton Rouge, LABuilt 1969 · S/N 733-70

Back to AD 80-25-07 R1