Registered aircraft · 72,001

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-10-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-10-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-10-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-10-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-10-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-10-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.

N242CMZlin Parts America LLC · Elmwood, WIBuilt 1994 · S/N 0661 N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715 N242DCRedtail Aviation Services LLC · Inglewood, CABuilt 1994 · S/N 0668 N242DFForce Dave Jr · Glenwood Springs, COBuilt 2005 · S/N 1 N242DGWing Over Aerobatics LLC · Weirsdale, FLBuilt 1995 · S/N 0687 N242DKInter Island Yachts Inc · Rncho Pls Vrd, CABuilt 1995 · S/N 0689 N242DSSneed Jason C · Spanish Fork, UTBuilt 1997 · S/N 001 N242DTSherlock William H · Greenbrae, CABuilt 1997 · S/N LRC-1 N242ENorman Brian D · Roseau, MNBuilt 1973 · S/N 17261819 N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229 N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234 N242GT25125 Inc · Wilmington, DEBuilt 2001 · S/N 2042 N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514 N242HRShine Dylan · Jupiter, FLBuilt 1998 · S/N 159 N242JMLitsky Steven H · University Place, WABuilt 1994 · S/N 0677 N242KFTio Pedro P · Miami, FLBuilt 2002 · S/N 3257277 N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111 N242LESky King Aviation Services Inc · Ardmore, OKBuilt 1990 · S/N 1 N242LHMatthews Micheal S · Reno, NVBuilt 1994 · S/N 0673 N242LPDavenport Rebecca · Fresno, CABuilt 2000 · S/N 24340 N242MEMike Echo Ventures LLC · Coral Gables, FLBuilt 2000 · S/N 20608112 N242MGHelo 1 LLC · Anchorage, AKBuilt 2006 · S/N 11134 N242MPWestwood Dave · Red Lodge, MTBuilt 1994 · S/N 0660 N242MZBechara Nizar E · Columbia, MDBuilt 1999 · S/N 0732 N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052 N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137 N242PHoeme Eric L · Leoti, KSBuilt 1967 · S/N 28-10998 N242RKBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 31-7512025 N242RSPape Brandon M · Mc Gregor, TXBuilt 1997 · S/N 2054 N242RVSearle Ronald Q · Franktown, COBuilt 2025 · S/N 41676 N242SBMartin Thomas R · Roseville, MNBuilt 1989 · S/N 001 N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226 N242STOlivier Andre · River Ridge, LABuilt 2003 · S/N 3313 N242TC182 Flight Corp · Bronx, NYBuilt 2005 · S/N T20608530 N242USilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608242 N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404 N24301Pacific Coast Cycle Corp · Kings Beach, CABuilt 1999 · S/N T20608139 N2430KTylenda John R · Bigelow, ARBuilt 2005 · S/N 22712 N2430YBuckman Arnold H Trustee · Spring Valley, ILBuilt 1985 · S/N 32R-8513002 N2431ESpartan College Of Aeronautics And Technology · Broomfield, COBuilt 1978 · S/N 17271280 N2431GGulf Coast Helicopters Inc · Pearland, TXBuilt 2000 · S/N 18280681 N2431QWade Consulting LLC · Aviston, ILBuilt 2000 · S/N 18280684 N2431SDavis Girls LLC · San Jose, CABuilt 1979 · S/N R18201340 N2432HErsland Ryan Peter · Anchorage, AKBuilt 1979 · S/N 18-7909184 N24337Dunn Craig M · Sarasota, FLBuilt 2000 · S/N 18280713 N2433EElco Electric · Bangor, MEBuilt 2000 · S/N 20608136 N2433MHarkey Aviation LLC · Sherrills Ford, NCBuilt 1977 · S/N 28-7816285 N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872 N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006 N24342Loma Aviation LLC · San Diego, CABuilt 1973 · S/N 287305419

Back to AD 87-10-06 R1