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.

N500GEStevenson Anesthesia Associates Pc · Wolfforth, TXBuilt 1977 · S/N E-1130 N500GGSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1990 · S/N E-2564 N500JLJet-H Inc · Oak Park, CABuilt 1991 · S/N CE-1603 N500LDJ & H Investment Corp Inc · Columbia, MOBuilt 1979 · S/N TH-1008 N500SBKostelic Tanner · Alpena, MIBuilt 1973 · S/N E-482 N500TLSententia LLC · Highland Park, ILBuilt 1999 · S/N TH-1890 N500WPWelker Franklin W · Agoura, CAS/N EA-582 N501KPWasson Ronald L · Colleyville, TXBuilt 1974 · S/N TJ-21 N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72 N5025WAdvanced Aircraft Engineering Inc · Amelia Island, FLBuilt 2001 · S/N EA-677 N502BWRomero Leasing Inc · Stuttgart, ARBuilt 1992 · S/N E-2716 N502TJBasden Richard A · Dallas, TXBuilt 1973 · S/N CE-468 N5036M66ee LLC · Santa Barbara, CABuilt 1978 · S/N E-1255 N503BAP&B Aviation Corp · Wilmington, DES/N TH-862 N504GLBravo Whiskey Solutions LLC · Brenham, TXBuilt 1975 · S/N TJ-26 N504SJAmerican Bonanza Society Air Safety Foundation Inc · Wichita, KSBuilt 1981 · S/N E-1849 N5050LFrederick Benjamin J · The Woodlands, TXBuilt 1977 · S/N E-986 N5056XN5056x LLC · Troy, OHS/N E-3456 N505TTWebber James F · Arvin, CABuilt 1972 · S/N E-376 N5065RZ J Express LLC · Lewes, DEBuilt 2002 · S/N TH-2040 N506HPPedden Patrick M · Fort Wayne, INBuilt 1969 · S/N D-9073 N5073CInternational Air Services Inc Trustee · Carson City, NVS/N EA-667 N5075YAlkota Of Kansas LLC · Wichita, KSBuilt 2001 · S/N EA-675 N5080RRodriguez Roberto F · Tampa, FLBuilt 2001 · S/N E-3386 N5081EGolden Alan · Wilmette, ILBuilt 2001 · S/N E-3401 N5083TClaar Brian · Spring, TXBuilt 1982 · S/N EA-287 N508DFStephens James Anthony · Baton Rouge, LABuilt 1990 · S/N E2541 N5092NMill-Run LLC · Lewes, DES/N D-9893 N5096RProvestment International LLC · West Melbourne, FLBuilt 2001 · S/N TH-1996 N509JMRegistered aircraftBuilt 1980 · S/N D10352 N509PTailwindsbikelyft LLC · Hannibal, MOBuilt 2000 · S/N TH-1947 N50HGBethune David Scott · Stockton, CABuilt 1979 · S/N TJ-217 N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141 N50LAMorris Industries Inc · Wichita, KSS/N EA-307 N50LWFlyer One LLC · Palm Harbor, FLBuilt 1970 · S/N TE-790 N50SSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2000 · S/N TH-1961 N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999 N510TCSkyview Aviation LLC · Hartwell, GAS/N E-1469 N511CMartin Gary N · Lake Jackson, TXBuilt 2004 · S/N E-3576 N511CFFendler Michael J · Pittsfield, MEBuilt 1977 · S/N TH-833 N511DFKma Aviation LLC · Phoenix, AZBuilt 1980 · S/N TH-1175 N511RAKeenan Michael John Trustee · Anchorage, AKS/N E-2746 N511SPFassas Alexander D · Richmond, KYBuilt 1976 · S/N E-910 N5128CLacey Nora B Trustee · Incline Village, NVBuilt 2002 · S/N E-3455 N512BDTurbo Aviation LLC · Chesterfield, SCS/N D-9398 N512SLSalmon Raymond A Trustee · Tavares, FLBuilt 1984 · S/N TJ-472 N5137BTextron Aviation Inc · Wichita, KSFirst renewal noticeBuilt 2007 · S/N E3547 N514AVDigirolamo Anthony S · Stow, MABuilt 1979 · S/N CE846 N514BKNot For Naught LLC · Wimberley, TXBuilt 1974 · S/N E-514 N514HRSethi Inderdeep Singh · Tracy, CABuilt 1980 · S/N EA-70

Back to AD 87-18-06 R1