Registered aircraft · 72,000

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.

N121HSCharles Dan H · Des Allemands, LAS/N 121 N121JAAlbers Edward J Jr · Oviedo, FLBuilt 1991 · S/N 121 N121JCNewsom William A · Cheraw, SCBuilt 2000 · S/N F0010 N121JLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1993 · S/N ODOM 0001 N121JZZack Jay T · Cloquet, MNBuilt 2002 · S/N 0121 N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836 N121LCJolisea Wings LLC · Palm Bay, FLBuilt 2003 · S/N 21161 N121LMGolden Age N121lm LLC · Des Moines, IABuilt 2022 · S/N 2881529 N121LTDream 10 LLC · Dunnellon, FLBuilt 2024 · S/N 42367 N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613 N121MNNielsen Mark C · Green Bay, WIBuilt 1997 · S/N MN-01 N121MSDarcy Aviation LLC · Danbury, CTBuilt 1978 · S/N 17271893 N121PGGinter Jon A · Marlton, NJBuilt 2005 · S/N 70731 N121PRPaulich John III · Naples, FLBuilt 2005 · S/N 71295 N121RFRafamedia LLC · Stamford, CTBuilt 1976 · S/N 13048 N121RLZaytsev Petr · Pflugerville, TXBuilt 1969 · S/N 690072 N121SClark William H IV · Thurmont, MDBuilt 1966 · S/N 32-835 N121SESpitzer Helicopter LLC · Woodland Hills, CABuilt 1997 · S/N 2747 N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475 N121SPFl280 LLC · Deland, FLBuilt 1960 · S/N 500B-984-25 N121SXRegistered aircraftBuilt 2018 · S/N 14147 N121TDelmarva Flight Leasing Inc · East Moriches, NYBuilt 1992 · S/N 270124 N121TCDonney Tom J · Sturgis, SDBuilt 1978 · S/N 32-7840105 N121TFTorres Juan · Modesto, CABuilt 2004 · S/N 3257351 N121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GABuilt 1977 · S/N 32R-7780301 N121UCEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280420 N121VKOcala Aviation Services Inc · Ocala, FLBuilt 1984 · S/N 17276101 N121VTWilliams Ralph J · Essex Junction, VTBuilt 2007 · S/N 99-1131 N121VUThomason Stewart A · Charleston, SCBuilt 1991 · S/N 10057 N121WMBarnes Robert B · Chico, CABuilt 1980 · S/N 638-80 N121WPRoy Frank W · Millinocket, MES/N 1382 N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880 N12202Hudson Kent O · Anchorage, AKBuilt 1972 · S/N 339-72 N12206Hth LLC · Merigold, MSBuilt 1972 · S/N 299-72 N12207Faris Isaac · Swartz Creek, MIBuilt 1972 · S/N 34272 N12208Shepard John A · Thornville, OHBuilt 1972 · S/N 300-72 N12209Melendez Jesus · North Miami, FLS/N 17261881 N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161 N1220HScroggs Jack F · Anchorage, AKBuilt 1948 · S/N 15AC-232 N1220RKeywestaero LLC · Wilmington, DEBuilt 2005 · S/N 18281582 N1220UParinger Glenn R · Nashotah, WIBuilt 1993 · S/N 0092 N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191 N1220ZColumbus State Community College · Columbus, OHBuilt 1959 · S/N 24-800 N12210Exclusive Motors Inc · Grand Prairie, TXBuilt 1973 · S/N 17261882 N12211Miller Todd B · Wayne, ILBuilt 1973 · S/N 17261883 N12212Wilson Donovan F · Friday Harbor, WABuilt 1973 · S/N 17261884 N12213Top Flight Aviation Inc · Corona, CABuilt 1973 · S/N 17261885 N12215Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17261887 N1221AGerbi Charles R Trustee · Auke Bay, AKBuilt 1951 · S/N 18-832 N1221LNewman James B · Albany, ORBuilt 1991 · S/N 10072

Back to AD 87-10-06 R1