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.

N14395Eastern Stearman Inc Trustee · Leesburg, VABuilt 1974 · S/N 18-7409093 N1439JBeckler Scott · Omaha, NEBuilt 1976 · S/N 439 N1439UCass Aviation LLC · Henderson, NVBuilt 1976 · S/N 17267106 N1439XDovy Aviation LLC · Houston, TXBuilt 1975 · S/N 28-7525301 N143ACPotcake Aviation LLC · Missoula, MTBuilt 1972 · S/N 27-7304989 N143AMMcgee Ronald S · Las Vegas, NVBuilt 1997 · S/N 1081 N143BHTappan Holdings Inc · Cadiz, OHS/N 21003C N143BSMoses Charles · West Friendship, MDBuilt 1966 · S/N 28-3792 N143CCAerial Messages Leasing Co · Longwood, FLBuilt 2003 · S/N 9956CC N143CHHiers Craig L · Moultrie, GABuilt 1978 · S/N 3562 N143DROroca Flying Club LLC · Weehawken, NJBuilt 1972 · S/N 17261119 N143DVBruns Luke J · Flower Mound, TXBuilt 2007 · S/N 40026 N143EBLewis Thomas B · Granbury, TXBuilt 2007 · S/N 40307 N143EYTriple D Aviation LLC · Merritt Island, FLBuilt 1968 · S/N 28-24348 N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178 N143GLLiebert Glenn W · New Albany, OHBuilt 1996 · S/N LIEBERT 0001 N143HPDans Aircraft Repair LLC · Gardiner, MTS/N NF0007 N143JDHarris Steven V · Springtown, TXFirst renewal noticeS/N 8083C N143JMMa Cedric Sek-Kong · Los Angeles, CABuilt 1964 · S/N 28-20358 N143KYClark Michael B · Montgomery, TXBuilt 1974 · S/N 31-7401255 N143LKRobbins Larry K · La Follette, TNBuilt 1994 · S/N 190 N143LWMurphy Law Office Pc · Rapid City, SDBuilt 1979 · S/N R18201265 N143MMPalo Michael Scott · Melbourne, FLBuilt 1970 · S/N 39-18 N143MYPeaks Rental LLC · Aurora, COBuilt 2004 · S/N 10478 N143PCFuqua Royce Owen · Early, TXBuilt 2004 · S/N 1379-2004 N143PROrtiz Ramon L · Teaneck, NJBuilt 1997 · S/N 22106 N143PSDrake Barbara A · Pensacola, FLBuilt 1986 · S/N 045 N143RNCollins Glen K Trustee · Appleton, NYBuilt 2012 · S/N 20385 N143RVLefevre Garrett R · Tucson, AZBuilt 1998 · S/N 22143 N143RWWendell Ross · Ankeny, IABuilt 2013 · S/N 40450 N143SDWhiskey Fox Group LLC · Destin, FLS/N 25005C N143TBSmith Timothy T · Turkey, NCBuilt 1979 · S/N 28-8011053 N143WScott Jeffrey E · Cherokee Village, ARBuilt 2011 · S/N 655 N143ZLYoder F David · Wellington, FLBuilt 1999 · S/N 0030 N14401Berggren Ryan · Newton, NJBuilt 1967 · S/N 27-3722 N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248 N1440XAlldredge Brad · Redlands, CABuilt 1963 · S/N 24-3478 N1441AStewart Aviation LLC · Seymour, INExpired dealer, pending cancellationBuilt 2018 · S/N 1441 N1441JErca Abby · Denton, TXS/N 441 N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993 N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579 N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728 N1442PJones Isaac W III · Alabaster, ALBuilt 2021 · S/N 140644 N1442TKeller Mark · Alexandria, KYBuilt 1972 · S/N 28-7205298 N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109 N1443DEc Aviation Group Corp · Ponte Vedra, FLBuilt 2000 · S/N 1097 N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580 N14443Mcdonald Gary Lee · Eatonville, WABuilt 2008 · S/N 3005 N1444JShoreys Francis · Northboro, MABuilt 1976 · S/N 444 N1444XWaddell Charles · Elk Grove, CABuilt 1975 · S/N 28R-7535283

Back to AD 87-10-06 R1