Registered aircraft · 72,010

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.

N586KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843917 N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297 N586SRice James L · Mckinney, TXBuilt 1981 · S/N 17274646 N586SBKareon Consulting LLC · Wilmington, DEBuilt 1966 · S/N 28-10781 N586TSUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 30076 N5870PPaul Eric C · Grapevine, TXBuilt 1959 · S/N 24-953 N5870QScott Stewart · Columbia, MOBuilt 1965 · S/N 3143 N5870UWhite Thomas A · Roanoke, TXBuilt 1970 · S/N 28-26702 N5870VHagerstown Regional Aero Club · Dallastown, PABuilt 1977 · S/N 32R-7780370 N5871LSleeper James A · Middleburg, FLBuilt 1972 · S/N AA5-0071 N5871NBraun Janet M · Pocono Pines, PABuilt 1978 · S/N 14416 N5871PHammons John A · Maurice, LABuilt 1959 · S/N 24-954 N5871QNeosho Investments LLC · Neosho, MOBuilt 1965 · S/N 800 N5872LMai David A · Chattanooga, TNBuilt 1972 · S/N AA5-0072 N5872NMeans Loren Alonzo III · Wasilla, AKBuilt 1978 · S/N 14417 N5872QAir Mods And Repair Inc · Robbinsville, NJBuilt 1965 · S/N 3144 N5873QSternhagen Richard A · Friendship, WIBuilt 1965 · S/N 801 N5873WPropst David A · Exchange, WVS/N 28-2503 N5874DFeuerborn Ethan T · Boise, IDBuilt 1960 · S/N 187453 N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707 N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708 N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209 N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557 N5876LWilson James · Bagwell, TXS/N AA5-0276 N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709 N5876WKiss George C · Bangor, PAS/N 28-2552 N5877FFeldvary John · Jackson, MIBuilt 1976 · S/N 28-7715155 N5877LFlyboys Aviation LLC · Sioux City, IABuilt 1972 · S/N AA5-0077 N5877NMeisner Shane · Fredericksburg, VABuilt 1978 · S/N 14422 N5877QKenyon Alexandrea A · Costa Mesa, CABuilt 1965 · S/N 803 N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505 N5878GConner Norman V · Lakewood, WABuilt 2005 · S/N 70179 N5878LGomez Blanco Rafael · Lakewood, CABuilt 1972 · S/N AA5-0078 N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710 N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555 N5878ZSallmon James H · Saratoga Springs, UTBuilt 2010 · S/N 001 N5879LN5879l LLC · Lewes, DEBuilt 1972 · S/N AA5-0229 N5879NBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 14424 N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713 N587AMPerry Monty R · Simi Valley, CABuilt 2022 · S/N 41966 N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928 N587KBSwihart Painting LLC · Bolivar, MOBuilt 1978 · S/N 103978 N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517 N587PAVan Hatten Michael Sr · Fairbanks, AKBuilt 1989 · S/N 1809033 N587SPPinnacle Aviation Services Inc · Encinitas, CABuilt 2000 · S/N 172S8518 N587WPLindner James F · Williamsburg, MIBuilt 2013 · S/N 62-123/124-868 N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950 N5880KCjc LLC · Syracuse, UTBuilt 2005 · S/N T20608581 N5880QSeely Scott · Edmond, OKBuilt 1965 · S/N 3148 N5880WDurkin Michael T · Sunland, CABuilt 1965 · S/N 28-2570

Back to AD 87-10-06 R1