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.

N950CAZero Charlie Alpha LLC · Mountain View, CABuilt 1974 · S/N D-9667 N950DCParmelee Charles G Trustee · Reno, NVBuilt 1982 · S/N EA280 N950MCL C Cattle Inc · Garden City, KSBuilt 1978 · S/N D-10171 N950PSPlane Services LLC · Twin Falls, IDS/N EA-337 N950VWillow Equipment LLC · Sharon Springs, KSBuilt 1975 · S/N E-747 N951DDPerkin Holding Co Inc · Saint Louis, MOS/N E-3491 N951DSDerrick Schmidt Enterprises Inc · Vinita, OKBuilt 1978 · S/N TH-898 N951LHBeech Time LLC · Lawrence, KSBuilt 1986 · S/N E-2300 N951MMChambers Wilbert Wayne Jr · Burlington, NCBuilt 1974 · S/N D-9707 N951POncourse LLC · Miami, FLBuilt 2001 · S/N TH-2015 N953DSShows Douglas · Seabrook, TXBuilt 1983 · S/N TJ-443 N954REvans William Heath · Groveton, TXBuilt 1981 · S/N CE-954 N955BRBuffalo River Aviation LLC · Bentonville, ARBuilt 1972 · S/N TH-230 N955GBBioventures Leasing Corporation LLC · Brookhaven, GABuilt 1999 · S/N E-3286 N955LJTk Healthcare Management LLC · Abilene, TXS/N E-3082 N956SBBeaux Air LLC · England, ARBuilt 1973 · S/N TE956 N956VParker Aerospace LLC · Warren, VTBuilt 1975 · S/N D-9817 N957PCPilot Realty Inc · Sackets Harbor, NYS/N TH-2023 N958CCSolomon Mark Trustee · Wilmington, DEBuilt 1989 · S/N TH-1565 N958DMDw Moyer Aviation Inc · Stroudsburg, PABuilt 1982 · S/N CE-1005 N958HCHydroair LLC · Auburn, ALBuilt 1999 · S/N TH-1891 N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139 N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392 N958WDBrush Art Corp · Downs, KSBuilt 1999 · S/N TH-1928 N95AJAvnuts LLC · Pawleys Island, SCBuilt 1978 · S/N E-1254 N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29 N95CFUes Bluesky Aviation LLC · New Berlin, WIBuilt 1988 · S/N CE-1291 N95DBBlankenbeker Edward D · Fernandina Beach, FLBuilt 1979 · S/N D-10239 N95DPNorthwest Aviation Inc · Oklahoma City, OKBuilt 1978 · S/N TE-1149 N95KMAerial Logistics LLC Trustee · Lakeland, FLBuilt 1981 · S/N TH-1315 N95PJMoghimi Gholamali · Monroe, LABuilt 1980 · S/N TH-1162 N95PNM&B Aviation Services LLC · Wilmington, DEBuilt 1972 · S/N TH-282 N95RRKentucky Oil And Refining Co · Betsy Layne, KYBuilt 1974 · S/N E-541 N95VPVarsity Produce Sales Inc · Bakersfield, CABuilt 1980 · S/N EA-114 N95WDBurleson Gary L · Myrtle Beach, SCBuilt 1971 · S/N CE-322 N95WHPage William R · Bermuda Dunes, CABuilt 1978 · S/N TK-86 N961WWMeacham Electric Inc · Marathon, FLBuilt 1970 · S/N CE316 N96335Cysewski Roxanne Trustee · Rllng Hls Est, CABuilt 1983 · S/N EA-400 N963SGElephant Shoe Air LLC · Vienna, VABuilt 1984 · S/N TJ-452 N964DCorporate Consulting Service Instruments Inc · Akron, OHBuilt 1981 · S/N TE-1190 N964MAMosier Marty R · Durham, NCBuilt 1984 · S/N EA-442 N964PBonanza 964 LLC · Davie, FLBuilt 1976 · S/N E-800 N966DEHubbard Richard O · Fort Worth, TXBuilt 1981 · S/N E-1865 N966UBTex Ark Air Corp · Melissa, TXBuilt 1977 · S/N TJ-120 N9675RBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1989 · S/N E-2503 N967EAMercury Air LLC · Torrance, CABuilt 2004 · S/N E-3567 N967VVolare USA Corp · Wilmington, DEFirst renewal noticeBuilt 1977 · S/N TH-851 N968PBank Of Utah Trustee · Salt Lake City, UTS/N E-3464 N9693ACavu LLC · Honolulu, HIBuilt 1991 · S/N TH-1627 N969YKarika Thomas · Merritt Island, FLBuilt 1972 · S/N E-322

Back to AD 87-18-06 R1