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.

N810MMSale Reported · Shreveport, LASale reportedBuilt 1969 · S/N 690020 N810SUApm Leasing LLC · Casper, WYBuilt 1979 · S/N 17272319 N811BJSix Pack Aviation LLC · Pocono Pines, PABuilt 1979 · S/N 17272287 N811HATate Grady · Harrisburg, NCS/N 17700181 N811JDSanders Jason C · Babylon, NYBuilt 1975 · S/N 17265353 N811SSFarabaugh Mark · San Diego, CABuilt 1967 · S/N 670064 N8122LWoodward Thomas M · Granbury, TXBuilt 1974 · S/N 177RG0610 N8126EAnderson Wilbur W Trustee · Lead Hill, ARBuilt 1978 · S/N 17272143 N812CPHigh Wing Air Services LLC · Merritt Island, FLBuilt 1977 · S/N 17268790 N812DDcc Aero LLC · Alamosa, COBuilt 1978 · S/N R18200853 N812DAHanson Aviation LLC · Winter Park, FLBuilt 1979 · S/N 17273577 N812LDRegistered aircraftBuilt 1980 · S/N R18201540 N812THSuss Charles H · Woodford, VTBuilt 1971 · S/N 17701615 N8130GBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 18801243T N8138LN8138l LLC · Metairie, LABuilt 1978 · S/N A1520828 N813JWComanche Air Inc · Tacoma, WAFirst renewal noticeBuilt 1972 · S/N 177RG0294 N813KMSantopietro Paul · Dunnellon, FLBuilt 2001 · S/N 1321-2001 N81425Pegasus Copters LLC · Makawao, HIBuilt 1945 · S/N 7AC-42 N814ACAlpine Aviation Inc · Grass Valley, CABuilt 1998 · S/N 814-98 N814RReed Mackenzie · Princeton, TXS/N 17260405 N815BCN815bc LLC · Post Falls, IDBuilt 2020 · S/N 609-2020 N8166AUnderwood Mack · Aiken, SCS/N 88973 N816LRegistration Pending · Anderson, SCRegistration pendingBuilt 1968 · S/N 17256833 N816LGGray James · Jupiter, FLBuilt 1977 · S/N 17268592 N816LLAero Equities LLC · Ventura, CABuilt 2003 · S/N 913-2003 N816RARochester Air Center LLC · Canandaigua, NYBuilt 1979 · S/N 17272388 N816TSCd Logic Inc · Wilmington, DEBuilt 1985 · S/N 24-1562 N816TXDavis Derek P · Sebastian, FLBuilt 1979 · S/N R18200811 N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147 N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574 N81772American Patrols Inc · Midland, TXS/N 17263860 N8179DGarza Jose R Jr · West Jordan, UTBuilt 1971 · S/N 177RG0009 N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003 N817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787 N8180MLeap Aviation Inc · Wilmington, DES/N 17260570 N8182ERed Arrow Aviation LLC · Santa Teresa, NMBuilt 1978 · S/N 17272148 N8184GAspire Aviation LLC · Farmingdale, NYBuilt 1979 · S/N 17273615 N818PCWindigo Transportation Inc · Waterloo, IABuilt 1982 · S/N P21000803 N818TSlipstream Aviation LLC · Carrollton, GAS/N 15283216 N818WDWhiskey Bravo II LLC · Newton, KSBuilt 2000 · S/N 856-2000 N819SMAnderson George M · Hattiesburg, MSBuilt 1979 · S/N 24-0802 N81BHPalmer Robert E · Cedar Key, FLBuilt 2011 · S/N 542-2011 N81DTKbk Aviation LLC · Youngsville, LAS/N 21064519 N81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeBuilt 1985 · S/N 172RG1184 N81KCCraigo Keith A · Addison, TXBuilt 1981 · S/N 21064386 N81LWCloud Seven LLC · Fort Pierce, FLBuilt 1976 · S/N 17702455 N81MTBennett Thomas Richard · Brooklyn Park, MNBuilt 1981 · S/N P21000794 N81PBCollins Jay D · Midwest City, OKBuilt 1964 · S/N 361 N81RPLull William G · Ramona, CABuilt 1971 · S/N 177RG0170 N81SDBurgess Jaret F · Fort Worth, TXS/N 922-2003

Back to AD 80-25-07 R1