OpenAirDocs.org
AD 2016-05-13

Registered aircraft · 3,126

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:2016-05-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-05-13')
  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.

N485JRGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N 20800264N487VCOaklr LLC · New York, NYBuilt 2001 · S/N BB-1757N488XJPartnership Management Inc · Midland, TXBuilt 1998 · S/N LJ-1527N489JDSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2002 · S/N 1059N48APBer Tanglewood Holdings LLC · Amarillo, TXBuilt 1999 · S/N LJ-1548N490SFWells Flying Services LLC · Holdrege, NEBuilt 2024 · S/N 802A-1152N491JVCessna 205 LLC · Austin, TXBuilt 1993 · S/N LJ-1349N491SCSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 2002 · S/N 235N4920YWindsock Aviation LLC · Old Saybrook, CTBuilt 2000 · S/N 169N492KKatmai Air LLC · Anchorage, AKBuilt 1957 · S/N 1185N494MAKing Lenny LLC · Fairview Park, OHBuilt 1986 · S/N FA108N496JBBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 602-1171N497GATri-State Aerial LLC · Canton, SDBuilt 1984 · S/N 400A-0502N497PCUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N 497N4982RParagon Air Group · Fort Worth, TXBuilt 1998 · S/N FL-224N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81N49BTFlight Levels LLC · Ridgeland, MSBuilt 2003 · S/N 4697161N49GM3-J Air LLC · Miami, OKBuilt 1982 · S/N 425-0165N49HFStanley Jason · Georgetown, TXBuilt 1988 · S/N 46-08125N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243N49RDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1975 · S/N BD02N49TWMulton Nutritional Services Inc · Kearney, NEBuilt 2023 · S/N 4698288N49WCWest Coast Aircraft Shares LLC · Santa Ana, CABuilt 1996 · S/N FL-144N4LGHmt Leasing LLC · Seabrook, TXBuilt 2001 · S/N FL-326N4YSRegistered aircraftBuilt 1992 · S/N FL-82N5001LAcme Aerial Application LLC · Seneca Falls, NYBuilt 1998 · S/N 502B-0513N5002JBcs Aerial LLC · Butler, MOBuilt 1998 · S/N 502B-0498N5002WSouther Crop Spraying Inc · Douglas, GABuilt 1997 · S/N 802A-0038N5003CCrop Air LLC · Eaton, COS/N 502B-0396N5004VTim Whitfield Aviation Inc · Fairfield, NCBuilt 1996 · S/N 502B-0400N5006KWoods Aviation LLC · Kearney, NEBuilt 1997 · S/N 402B-1024N50071South Delta Aviation Inc · West Helena, ARBuilt 1996 · S/N 402B-1019N5007GWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 1997 · S/N 502B-0417N5008LOlathe Spray Service Inc · Olathe, COBuilt 1996 · S/N 402B-1018N5009SBrignac Flying Service LLC · Columbus, MSBuilt 1996 · S/N 502B-0402N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387N500HAWandering Quarks LLC · Lincolnville, MEBuilt 2005 · S/N 4697222N500JM500jm Aviation LLC · Westfield, INBuilt 2001 · S/N 4697118N500SEPjh Consulting LLC · Reno, NVBuilt 1994 · S/N FL125N5010JGc Aviation LLC · Kalispell, MTBuilt 1997 · S/N 502B-0419N5012CVan Namen Jonathan E · Benoit, MSBuilt 1997 · S/N 502B0411N5018JRegistration Pending · Littlefield, TXRegistration pending, pending cancellationBuilt 1997 · S/N 502B-0432N5019AReabe Spraying Service Inc · Plover, WIBuilt 1997 · S/N 502B-0415N5019YAir Sprayers Inc · Two Buttes, COS/N 402A-1071N501DUWaterside Holdings LLC · Knoxville, TNBuilt 1980 · S/N LA-82N501HKBam Aviation LLC · Baton Rouge, LABuilt 1979 · S/N BB-565N501JC4l A/C Leasing LLC · Port Saint Lucie, FLBuilt 2013 · S/N 802A-0501N5022CCleveland Air Service Inc · Cleveland, MSBuilt 1998 · S/N 502B-0479N50256Panola Flying Service LLC · Lake Providence, LABuilt 1998 · S/N 402A-1059N502CKPot Hook Leasing LLC · San Benito, TXBuilt 2022 · S/N 502A-3345
Back to AD 2016-05-13