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.

N988JGSaratoga Aviation LLC · Wilmington, DEBuilt 1999 · S/N EA-638 N988YTMdf Ventures LLC · Los Angeles, CABuilt 2001 · S/N EA-685 N989BMHornung Kirk F · Beavercreek, OHS/N E-964 N989SAAir Kraft Spraying Inc · Timber Lake, SDBuilt 2001 · S/N EA-689 N98AABruno Anthony J III · Bryn Mawr, PABuilt 1985 · S/N TH-1461 N98BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N TJ-193 N98DCCayuga Copters Inc · Cynthiana, KYBuilt 1972 · S/N TE-865 N98JKIntagliata Joseph V · Hanna, INBuilt 1998 · S/N EA-609 N98LKMb Duncan Inc · Bakersfield, CABuilt 1977 · S/N D-10027 N98LRZ Corp Inc · Middletown, DEBuilt 1997 · S/N E-3126 N98MRAviato LLC · Heath, TXBuilt 1978 · S/N D-10119 N98MWSmith William E Jr · Havre De Grace, MDBuilt 1988 · S/N CE-1228 N98PSSchuessler Scott · Stillwater, OKBuilt 1977 · S/N D-9996 N98RETwin Star Hot Springs LLC · Hot Springs, ARBuilt 1977 · S/N TJ-108 N98VCVictor Adventures LLC · Ottawa, OHBuilt 1998 · S/N E-3170 N98WENorthern Aviation LLC · Roberts, MTBuilt 1997 · S/N E-3146 N990TSKem Investments LLC · Wichita, KSBuilt 1990 · S/N CE-1537 N991GLCrestron Electronics Inc · Rockleigh, NJS/N E-2953 N992TLMulzer Timothy J · Santa Claus, INBuilt 1992 · S/N E-2715 N993MDBoyd Aviation LLC · Lakeville, MNBuilt 1984 · S/N CE1029 N994WYInternational Air Services Inc Trustee · Carson City, NVS/N TE-1001 N9955MBell Jason W · Mount Pleasant, TXBuilt 1989 · S/N TH-1575 N995EGEagle Group USA Inc · Howell, MIBuilt 1980 · S/N EA-90 N9968PFlax Brian J · Germantown, TNBuilt 1997 · S/N E-3109 N996FInloes Mechanical Utah LLC · Ogden, UTBuilt 1996 · S/N E-3042 N996JKFletcher Flying Service 419 LLC · Labelle, FLBuilt 1996 · S/N E-3051 N996VWakeman Donald H · Hanover, NHBuilt 1980 · S/N E-1654 N997BBBlankenship John R · Weirsdale, FLBuilt 1980 · S/N D-10328 N997JS & C Aero LLC · Collierville, TNBuilt 1974 · S/N CE-498 N998BBWw Aero LLC · Jonesboro, ARBuilt 1983 · S/N E-2113 N998JGDragonfly Aviation LLC · Davie, FLBuilt 1999 · S/N EA-641 N998LSTalton Rentals LLC · Tupelo, MSBuilt 1998 · S/N E-3204 N998PLStormy Aviation LLC · Fargo, NDBuilt 1996 · S/N E-3036 N998PMWirth Aviation LLC · Scottsdale, AZBuilt 1999 · S/N E-3251 N99910Roof Management Ltd · Marysville, OHBuilt 1975 · S/N D-9767 N99914Roof Management Ltd · Marysville, OHBuilt 1970 · S/N D-9178 N9993Pro Team Aviation LLC · Jonesboro, ARBuilt 1970 · S/N D-9175 N999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N EA-417 N999AKBarber Aviation LLC · Wilmington, DEBuilt 1979 · S/N TH-1069 N999BFRigel Aviation Inc · Jefferson Hills, PABuilt 1979 · S/N EA-24 N999CECb Wings LLC · Eugene, ORBuilt 1980 · S/N EA-86 N999CWDunn Mark P · Visalia, CABuilt 1973 · S/N TH-291 N999DPRobinson Aviation Holdings LLC · Houston, TXBuilt 1971 · S/N D-9263 N999FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1988 · S/N CE-1282 N999FBDelia Salvatore · Rocky Point, NYBuilt 1979 · S/N E-1495 N999KTSmith John C B · West Palm Beach, FLS/N TJ-483 N999PGRegistered aircraftBuilt 1995 · S/N E-2955 N999PZBs Starbellies LLC · Austin, TXBuilt 1979 · S/N E-1483 N999SGHuskey Eugene Donald Jr · Leesburg, TXBuilt 1981 · S/N E-1963 N999SKWkqm LLC · Wilmington, DEBuilt 1997 · S/N TH-1815

Back to AD 87-18-06 R1