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.

N4759MTempel Warren K · Longmont, COBuilt 1978 · S/N E-1300 N475ECGarcia Paola Olivares · El Paso, TXBuilt 1979 · S/N E-1446 N475JGwaltney Air Inc · Alexander City, ALBuilt 1994 · S/N E-2883 N475JMSmm Aviation LLC · Destin, FLBuilt 2001 · S/N E-3368 N4764MSpooner James Leonard · Carlisle, PAS/N CE-782 N4764YOk3wire Properties LLC · Pensacola, FLBuilt 1973 · S/N D-9418 N4766MFx5 Construction & Excavation Inc · Decatur, TXBuilt 1978 · S/N E-1259 N476EWWny Air Inc · Dover, DEBuilt 1996 · S/N TH-1797 N476JMJp Air LLC · Kalispell, MTBuilt 1979 · S/N E-1397 N476WBurkhard Daniel A · Vero Beach, FLBuilt 1979 · S/N D-10286 N4775MJ And J Consulting LLC · South Jamesport, NYBuilt 1978 · S/N D-10131 N477RBNwl Capital Holdings LLC · Black Eagle, MTBuilt 1974 · S/N D-9685 N477WCAllison Medical Solutions LLC · Lumberton, MSBuilt 1977 · S/N E-1065 N4796MN4796m LLC · Norridge, ILBuilt 1978 · S/N D-10133 N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801 N479KSHaaverson Enterprises Inc · Livermore, CABuilt 1993 · S/N E-2811 N47GAJcb Air LLC · Southport, NCBuilt 1975 · S/N TH-547 N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207 N47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARBuilt 1973 · S/N D-9432 N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530 N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142 N47TJJ & S Aero LLC · Port Washington, NYBuilt 1988 · S/N CE1288 N480JKAugust-Marie Inc · Wilmington, DEBuilt 1997 · S/N E3103 N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265 N481SAerogracia LLC · Heritage Ranch, CABuilt 1970 · S/N D-9094 N4828MHodges William T · Andersonville, GABuilt 1978 · S/N E-1269 N4831MBoty Aero LLC · Madison, ALBuilt 1978 · S/N E-1273 N48458Peterson Timothy R · Monument, COBuilt 1971 · S/N D-9291 N484DAlman Inc · Fort Lauderdale, FLBuilt 1992 · S/N CE-1699 N485HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1328 N486HPSlipstream Aviation LLC · La Crosse, WIBuilt 1989 · S/N CE-1342 N487HPAlpha Niner Niner LLC · Winter Garden, FLBuilt 1989 · S/N CE-1333 N488DPRodarte Lionel · Downey, CABuilt 1974 · S/N E-522 N488HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1338 N488JMThorup Scott I · Abilene, TXBuilt 1984 · S/N E-2140 N489HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1989 · S/N CE-1343 N48BWBroadmoor Bed And Breakfast LLC · Colorado Springs, COBuilt 1975 · S/N CE-582 N48CCC Baron LLC · Lafayette, LAFirst renewal noticeBuilt 1981 · S/N TH-1277 N48CMR Stephen Smith Inc · Wichita, KSS/N TE-985 N48JClever Conceptz LLC · Danbury, CTS/N TH-409 N48JHFlying O Consulting LLC · Hammon, OKBuilt 1971 · S/N E-297 N48KUWildcat Aviation LLC · Wilmington, DEBuilt 1979 · S/N D-10303 N48MHSeventh North Hangar LLC · Bolton, MAS/N D-9184 N48RKKinnischtzke Lyle V · Mandan, NDBuilt 1989 · S/N CE-1396 N48TIndian Springs Cattle Co Ltd · Wilmington, DEBuilt 2000 · S/N E-3320 N48TXCulater LLC · Indianapolis, INBuilt 1985 · S/N TH-1493 N48TZVisibility Unlimited LLC · Carbon, INS/N E-1804 N48WCBaron Acquisition LLC · Wayne, PABuilt 1981 · S/N TJ-350 N48WWSupercub Aviation LLC · College Station, TXBuilt 1976 · S/N E-940 N490HPBreit Sky Aviation LLC · Sioux Falls, SDBuilt 1989 · S/N CE-1335

Back to AD 87-18-06 R1