Registered aircraft · 6,238

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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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:87-18-06-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.

N115WEPhilips Robert Jay · Midlothian, TXBuilt 1976 · S/N TK-15 N1163TIrish Aviation Inc · Orlando, FLBuilt 1975 · S/N TE-1033 N1165TFlying J Partners Asset Management LLC · Casper, WYBuilt 1975 · S/N D-9754 N1168TKnight Oil Resources Inc · New Orleans, LABuilt 1975 · S/N TE-1045 N1169TMorin Daniel P · New Harbor, MEBuilt 1975 · S/N D-9770 N116ABHaller Phillip · Peoria, AZBuilt 1973 · S/N TE-899 N116BDTxbd Investments LLC · Addison, TXBuilt 2002 · S/N E-3454 N116TWHatfield David A · West Ossipee, NHBuilt 1973 · S/N D-9529 N1170TJf Capital Series LLC · Truckee, CABuilt 1975 · S/N D-9777 N1174TDynamic Erp Resources Inc · Mansfield, TXBuilt 1975 · S/N TE-1056 N1175TCleared For The Option Aviation Services LLC · Kingwood, TXBuilt 1975 · S/N TH-604 N1178TDavis Aviation Group LLC · Gastonia, NCBuilt 1975 · S/N E-794 N1179TQuad Rabbit Inc · Wilmington, DEBuilt 1977 · S/N E-1124 N117ECRambana & Ricci Pllc · Tallahassee, FLBuilt 1977 · S/N E-1118 N117KASouthern Latitude LLC · Alabaster, ALBuilt 1972 · S/N TE-852 N117RSJa1 Aviation LLC · Sedan, KSBuilt 1979 · S/N TJ-224 N1183Sweet Aviation LLC · Dover, DEBuilt 1980 · S/N TE 1183 N1184JD&D Chessies LLC · Wilmington, DEBuilt 1980 · S/N E1690 N118CFChaudoin Stephen G Trustee · Raymond, NHBuilt 1978 · S/N TH-924 N118CMEastport Vacation LLC · Wilmington, DEBuilt 1977 · S/N CE-707 N118EDSouth America Tactical & Airborne Cousulting Corp · Wilmington, DEBuilt 1974 · S/N TE-1013 N118NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1991 · S/N CE-1612 N118TBColtman Peter O · Colleyville, TXBuilt 1981 · S/N E-1891 N1191DFas Holdings LLC · Osage Beach, MOBuilt 1986 · S/N TH-1506 N1195TRoberts Robin W · Birmingham, ALBuilt 1974 · S/N E-629 N119ACKidd Kevin A · Key West, FLBuilt 1972 · S/N TH-188 N119EWBte Aviation LLC · Wilmington, DEBuilt 1981 · S/N E-1863 N119TTBurrell Anthony · Stillwater, OKBuilt 1981 · S/N D-10369 N119TWCarter Flygare Inc · Sacramento, CABuilt 1974 · S/N TH-533 N11BCBledsoe Lucile M · Wray, COBuilt 1991 · S/N EA-515 N11BXMatthew K Cole · Gillespie, ILBuilt 1972 · S/N CE-388 N11ECBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1970 · S/N TH-128 N11EVBonita Beech LLC · Bonita Springs, FLBuilt 1976 · S/N TH-748 N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298 N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234 N11RLBeech Life LLC · Houston, TXBuilt 1980 · S/N EA120 N11RMHaig Amy · Redlands, CABuilt 1993 · S/N EA-553 N11UYInternational Air Services Inc Trustee · Carson City, NVS/N EA-218 N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891 N11VZLowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N E-397 N11WPPlacer Aviation LLC · Loomis, CABuilt 1990 · S/N E-2546 N11XMWesley F Walker · Rock Hill, SCBuilt 1999 · S/N E-3225 N11YPDanforth Equipment LLC · Leesburg, FLBuilt 1987 · S/N TH-1509 N120DBB & I Leasing LLC · Berryville, VABuilt 1978 · S/N E1276 N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248 N120WTZulu Time LLC · Park City, UTBuilt 1980 · S/N EA-99 N1212GNickeson Family LLC · Maquoketa, IABuilt 1988 · S/N E-2418 N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254 N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126 N121BLOlson Brian D · Las Vegas, NVBuilt 1982 · S/N TJ-413

Back to AD 87-18-06 R1