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.

N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N1516VAircraft Management Services Inc · Milton, FLBuilt 1974 · S/N 17263638 N1516XNorthern James E · Oakdale, CABuilt 1973 · S/N 379-73 N1517EHeavy Metal Air LLC · Farmingdale, NYFirst renewal noticeBuilt 1978 · S/N 17271031 N1519VBent Prop LLC · Inver Grove, MNBuilt 1974 · S/N 17263641 N151BHRajnarayan Dev Gorur · Mountain View, CABuilt 2008 · S/N 1061-2008 N151DB1 Zero Sierra Whisky LLC · Helena, MTBuilt 1965 · S/N 832 N151JSPerkins E G Jr · Greenwood, MSBuilt 1994 · S/N 738-94 N151PCWear Thomas M · Bridgewater, NJBuilt 2001 · S/N 884-2001 N151SAKennedy Jon P · Gillette, WYBuilt 2008 · S/N 1448-2008 N151VJonathan Wise & Associates Inc · Edmond, OKBuilt 1979 · S/N 550-79 N151VUVincennes University · Indianapolis, INBuilt 1980 · S/N 172RG0667 N1521HHopkins John C Jr · Tallulah, LABuilt 1975 · S/N 177RG0698 N1522VDawn Patrol Flying Club Inc · Northville, MIBuilt 1974 · S/N 17263643 N1523VSchmitz Barbara B · Oshkosh, WIBuilt 1974 · S/N 17263644 N1525HKubasch Kevin M · Longville, MNBuilt 1975 · S/N 177RG0701 N1526HThompson Roy Dayton · Bulverde, TXBuilt 1975 · S/N 177RG0702 N1526VRl Aviation LLC · Miami, FLBuilt 1974 · S/N 17263645 N152APGood Life Aviation LLC · San Tan Valley, AZBuilt 1982 · S/N A1521015 N152AWYouth Missions Aviation Academy Inc · Southlake, TXBuilt 1985 · S/N 15285977 N152AZRegistration Pending · Long Beach, CARegistration pendingBuilt 1979 · S/N 15283886 N152BBJensen Harold G · San Antonio, TXBuilt 1979 · S/N 15283831 N152BJMissionaire LLC · Kennedy, NYBuilt 1982 · S/N 152-85670 N152BMPluska Paul · Hansville, WABuilt 1978 · S/N A1520831 N152BPBaker John A · Cape Coral, FLBuilt 1977 · S/N 15281066 N152BTCoho Aviation LLC · Hillsboro, ORBuilt 1980 · S/N P21000486 N152BUGreen Airport Development Corp · Kemah, TXBuilt 1983 · S/N 15285698 N152CJFoss Fred C · Naperville, ILBuilt 1978 · S/N 15281682 N152DMHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 15280302 N152DXCastracane Mark A · Hattiesburg, MSBuilt 1984 · S/N 15285886 N152DZPopovitch Michael P · Marina, CABuilt 1978 · S/N 15281491 N152EF47 North Aviation LLC · Wenatchee, WABuilt 1979 · S/N 15283975 N152ERAviat Aircraft Inc · Afton, WYBuilt 1978 · S/N 15282469 N152FASomnium Volans LLC · Walton Hills, OHBuilt 1979 · S/N 15283937 N152FCNygren Shad · Fallon, NVBuilt 1979 · S/N 15283642 N152GBHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279546 N152GFBright Shaji · Martinez, GABuilt 1978 · S/N 15282309 N152GSBitondo Steven S · Mamaroneck, NYBuilt 1978 · S/N 15282256 N152GTHansen Nelse · Lawrenceville, GABuilt 1977 · S/N 15279503 N152HFBaier Dale Edwin · Colleyville, TXBuilt 1977 · S/N 15279555 N152HRWarner James A · Watertown, NYBuilt 1980 · S/N 15284697 N152HWWuertz Errol Gene Jr · Mcpherson, KSBuilt 1978 · S/N 15281995 N152JPatterson Casey Paul · Kinston, ALBuilt 1979 · S/N 15283162 N152JLCivil Air Support LLC · Phoenix, AZBuilt 1978 · S/N 15281834 N152LBurdick Rich · Montrose, COBuilt 1979 · S/N 15283964 N152LEBirjandi Akbar · Westlake Village, CABuilt 1978 · S/N 15282306 N152LTMorcom Aviation Services Inc DBA · Everett, WABuilt 1981 · S/N 15285262 N152MCOkechukwu Christopher · Paramus, NJBuilt 1977 · S/N 15279798 N152MFMja Flight LLC · Justin, TXBuilt 1981 · S/N 15284867 N152MMWiegler Michael · Austin, TXS/N 15280836

Back to AD 80-25-07 R1