OpenAirDocs.org
AD 87-10-06 R1

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
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.

N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004N1445HNelson Joshua M · Eagle, IDBuilt 1999 · S/N 3257092N1445TWhelan And Sons Realty LLC · Suffield, CTBuilt 1972 · S/N 28R-7235290N1446XN15956 Inc · Wilmington, DEBuilt 1975 · S/N 28-7525317N1447HMarkovich David E · Eden Prairie, MNBuilt 1977 · S/N 28-7725144N1447JCapital Auto Sales · Hickman, NEBuilt 1976 · S/N 447N1447TDa Silva Paulo E · Orlando, FLS/N 28R-7235292N1447XGaventa Edward J · Logan Twp, NJBuilt 1975 · S/N 28-7525318N1447ZHildebrand Dean A · Mesquite, TXBuilt 2012 · S/N 73178N1448XMallett Robert T · Wilmington, MABuilt 1975 · S/N 28-7505229N1449Registered aircraftBuilt 2007 · S/N 7086N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005N1449JAlpha Zulu Aviation LLC · Paragould, ARS/N 449N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586N144AFHelius Aircraft 144af LLC · Conroe, TXBuilt 2007 · S/N 1787N144AHAtomic Helicopters LLC · Seattle, WABuilt 2001 · S/N 0865N144AKExpress Helicopters LLC · Houston, TXBuilt 2004 · S/N 10226N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903N144AZBartosh Jason R · Big Pine Key, FLBuilt 1995 · S/N 21911N144BCThomas George E · Rice, WAS/N 188N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101N144BZCrosswind Leasing LLC · Prescott, AZBuilt 2005 · S/N 10715N144CCNightingale William T III · Rancho Cucamonga, CABuilt 1975 · S/N AA5B-84N144CDLittle Gator Aviation Inc · Fairfield, NCBuilt 1999 · S/N 0602N144CLStewart Joseph W II · Eloy, AZBuilt 2006 · S/N 10980N144CNGalliot Bond LLC · Atlanta, GAS/N 27-8054036N144CPHobgood Mitch D · Tylertown, MSBuilt 2024 · S/N 20420N144DFPessel William O Jr · Princeton, NJBuilt 1993 · S/N 1907N144DHSky 1 Inc · Wilmington, DEBuilt 1996 · S/N 1219-96N144DJSaybrook Offshore LLC · Guilford, CTBuilt 2017 · S/N 2467N144DMExecutive Helicopters Inc · Myrtle Beach, SCBuilt 2003 · S/N 10044N144DRSchneider Robert Keith · Bolivar, TNS/N 23587N144DSStevenson William E · Sutton, AKBuilt 2000 · S/N 0715N144DVAnderson Darrell L · Great Falls, MTBuilt 2016 · S/N 2850N144DZAurora Helicopters LLC · Lansing, ILBuilt 2003 · S/N 10100N144EBCavu Aviation LLC · Noblesville, INBuilt 2003 · S/N 270322N144EHScout Aviation LLC · Odessa, TXBuilt 2005 · S/N 10742N144ESSpain Heliventures LLC · Wilmington, DEBuilt 2003 · S/N 10228N144EZFlorida Aviation LLC · Tallahassee, FLS/N 32R-7885184N144FLSouth Florida Helicopters Inc · Indiantown, FLS/N 0654N144HRRsa Aviation Enterprises LLC · Peachtree City, GABuilt 2005 · S/N 153N144JGMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2000 · S/N 0859N144JJQcp Group LLC · Lafayette, LABuilt 1999 · S/N 0689N144JMBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1967 · S/N 18-8589N144KTBibb Richard E · Locust Grove, VABuilt 1997 · S/N 1187N144LDSchwartz Daniel James · Lannon, WIBuilt 2000 · S/N 4080N144LLLechner Larry A · Ithaca, NYS/N RV4-3753N144MBBoarman Mark A · Clarkdale, AZBuilt 2007 · S/N 2866
Back to AD 87-10-06 R1