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.

N44AKAvcom Co · Friday Harbor, WABuilt 1978 · S/N 61P-0481-194 N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012 N44BKBirum Kevin M · Kingston, WABuilt 2001 · S/N 5573 N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854 N44BWMariani Aviation Services LLC · Vero Beach, FLBuilt 1987 · S/N 219 N44CAWiley Commercial Property Consulting Inc · Aitkin, MNBuilt 1980 · S/N R18201556 N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037 N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1 N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488 N44DQTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2005 · S/N 10821 N44DZWanted Poster Owners Group LLC · York, PABuilt 1973 · S/N 32-7300046 N44EKBas Part Sales LLC · Greeley, COS/N 0690 N44EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 1-0058 N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500 N44FSJinsky Ronald G · Beloit, WIBuilt 1975 · S/N 717 N44GDCarver Michael A · Ocala, FLBuilt 2009 · S/N 004 N44GWReed Aviation LLC · Williamsport, PABuilt 2000 · S/N 4636276 N44HDAir Assault Agricultural Aviation LLC · New Castle, VABuilt 2005 · S/N 1498 N44HGHigher Ground Helicopters Of Cincinnati LLC · Miamisburg, OHBuilt 1995 · S/N 0214 N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597 N44HNCedar Ridge Aviation LLC · Knox City, TXBuilt 2005 · S/N 1455 N44HUFritsche James G · Greenleaf, WIBuilt 1997 · S/N 1353 N44HVMarinella Steve · Chandler, AZBuilt 2003 · S/N 6056 N44HYCochran Thomas S · Fort Collins, COBuilt 2001 · S/N 2145 N44JAJersey Aero Club Inc · Lakewood, NJBuilt 1983 · S/N 32-8306031 N44JLBushcat Goldie LLC · Oro Valley, AZBuilt 2015 · S/N 72279 N44JRRodgers Jerry T · Bishop, CABuilt 1997 · S/N 24545 N44JUEcho Mike Consulting LLC · Wilmington, DEBuilt 2004 · S/N 10517 N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106 N44KGSpanogle Michael M · Chugiak, AKBuilt 1989 · S/N 4074C N44KLStell Brandon A · Mechanicsville, VAS/N 803 N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904 N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400 N44LNBrown Bear Air Inc · Anchorage, AKBuilt 2005 · S/N 10848 N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1 N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348 N44PCGenocchio Anthony F · New Port Richey, FLBuilt 1965 · S/N 24-4124 N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800 N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001 N44PHHatch Fletcher A III · Vero Beach, FLBuilt 2002 · S/N 0002 N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209 N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576 N44PTDaedalus Flight Service Inc · P FokaiaBuilt 1972 · S/N 27-4793 N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147 N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543 N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446 N44QQEastern Stearman Inc Trustee · Leesburg, VABuilt 2000 · S/N 6034 N44RLCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 31-7401217 N44RRRichardson Robert L · Rch Palos Vrd, CABuilt 1985 · S/N R-1 N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927

Back to AD 87-10-06 R1