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.

N5678QPerkins C Trent B · Naubinway, MIBuilt 1965 · S/N 695 N5678UPaul William R · Oconomowoc, WIBuilt 1969 · S/N 28-26475 N5678WMckinney Douglas Andrew · Hastings, MNBuilt 1963 · S/N 28-913 N5678YTaildragger LLC · Glade Spring, VAS/N 18-8317 N56790Bradfield Breyson · Mandaree, NDBuilt 1973 · S/N 28R-7435042 N56791Brosher Melvin G · Decaturville, TNS/N 28R-7435043 N56793Dodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 32-7400009 N56798Warrior Airways LLC · Coral Springs, FLBuilt 1973 · S/N 28-7415013 N5679DAce Flight Center Inc · Saint Thomas, VIFirst renewal noticeBuilt 1959 · S/N TD-188 N5679PKuehnert Stefan · Clarkesville, GABuilt 1959 · S/N 24-751 N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038 N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122 N5679UInverted Holdings LLC · Newnan, GABuilt 1969 · S/N 28-26476 N567BBBeers Suzanne M · Colorado Springs, COBuilt 1973 · S/N 17701880 N567DHDoyel Landy N · Klamath Falls, ORBuilt 1998 · S/N 5152 N567GAAdkins Gordon L · Kenova, WVBuilt 2004 · S/N 3668 N567JBenike Ross A · Birchdale, MNBuilt 2002 · S/N 5677 N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187 N567LUS Department Of The Interior · Boise, IDBuilt 2016 · S/N CC18-0080 N567MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.308 N567RRGist Aviation LLC · Austin, TXS/N PX1520015 N567RVMarini Robert A · Brighton, COBuilt 1991 · S/N 20567-RV6 N567SFCockpit LLC · Melbourne, FLS/N 002 N567SHSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 1859 N567TB567tb LLC · Rockford, OHBuilt 1999 · S/N 1915 N567TCRegistration Pending · Platteville, WIRegistration pending, pending cancellationBuilt 1970 · S/N 39-63 N567VEEngbring Jered · Durango, COBuilt 2026 · S/N JE001 N56809Hudak Susanne Marie · Gold Canyon, AZS/N 28-7425041 N5680VTime To Fly LLC · Cleveland, MSBuilt 1977 · S/N 28-7716198 N5680WGoines Courtnee J · Jacksonville, FLS/N 28-931 N5680YSchildberg Gregory M · Casey, IABuilt 1965 · S/N 18-8292 N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039 N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91 N5681VNewell & Sons · Roxboro, NCBuilt 1977 · S/N 28-7790495 N56821Cowlin Aviation LLC · Houston, TXBuilt 1973 · S/N 28-7425046 N56822Tanner Timothy S · Norton, KSBuilt 1973 · S/N 28R-7435047 N56823Fly Tu9 LLC · Vancouver, WABuilt 1973 · S/N 28R-7435048 N56824Roberts Jeremy · Draper, UTBuilt 1973 · S/N 32-7440029 N56828Gillette Daniel R · Chillicothe, ILBuilt 1973 · S/N 28-7425048 N5682QNagel Mildred J · Akron, OHS/N 697 N5682VSgm Contractors LLC · Great Falls, VABuilt 1977 · S/N 28-7790496 N5682WRiggin Flight Service Inc · Madison, SDBuilt 1962 · S/N 28-938 N56831Burns Robert A · Fort Myers, FLFirst renewal noticeBuilt 1973 · S/N 28-7415015 N56834Maslonka Bradley James · Prior Lake, MNBuilt 1973 · S/N 28R-7435049 N56836Spj Aviation Holdings LLC · Bentonville, ARBuilt 1973 · S/N 32-7440030 N5683WYanta Chris · Rockport, TXBuilt 1962 · S/N 28-940 N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799 N56847Nepsund Michael L · Park Rapids, MNBuilt 1973 · S/N 28-7415017 N56849Macair Aviation LLC · Xenia, OHBuilt 1973 · S/N 28-7415018 N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756

Back to AD 87-10-06 R1