OpenAirDocs.org
AD 2001-08-14 R1

Registered aircraft · 95

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:2001-08-14-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:2001-08-14-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.

N409HHIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2008 · S/N 1561N418MDMountain Air Helicopters Inc · Dover, DEBuilt 2004 · S/N 3848N419AEBlue Card LLC · Plymouth, MABuilt 2000 · S/N 1161N441AHElite Rotorcraft LLC · Mt Juliet, TNBuilt 2006 · S/N 1426N449AEBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1194N451VEuro Tech Vertical Flight Solution LLC · Eudora, KSBuilt 2010 · S/N 1652N452VEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2011 · S/N 1656N45ECBay Helicopters LLC · Redwood City, CABuilt 2006 · S/N 1425N504LHAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 0382N504MCBhh Leasing #4 LLC · Pensacola, FLS/N 1159N514JDCity Of Fresno Police Department · Fresno, CABuilt 2002 · S/N 1309N514JPShore Properties Inc · Yakima, WABuilt 2008 · S/N 1576N520DTCity Of San Antonio Texas · San Antonio, TXBuilt 2015 · S/N 1688N524ALLcd Aviation Corp · Toa Baja, PRBuilt 2001 · S/N 1263N524MWCity Of Fresno · Fresno, CABuilt 2004 · S/N 1371N52ECDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 1291N573AGEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2013 · S/N 1683N600AMTower Aviation Of Reading Inc · Reading, PABuilt 2000 · S/N 1078N60ZXTonik Air LLC · Las Vegas, NVBuilt 1998 · S/N 0039N63HTHeli-Partners LLC · Orlando, FLBuilt 1999 · S/N 1033N64GDLittle Rhino LLC · Prosper, TXBuilt 1999 · S/N 1080N715PJFlying Farmer LLC · Wilmington, DEBuilt 2007 · S/N 1494N722WAAdkins Aviation LLC · Cornelius, NCBuilt 2012 · S/N 1668N775TCUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3622N77CWJani-King International Inc · Addison, TXBuilt 2000 · S/N 1087N802MHWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3707N820PMHeli Ranch LLC · Bulverde, TXBuilt 2013 · S/N 1686N822ETHall Health Systems Inc · Miami Beach, FLBuilt 2006 · S/N 1456N82PVEc 120 II LLC · Leesburg, VAS/N 1391N845BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3464N846BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3542N856BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3617N869CARv Aviation LLC · Wind Gap, PABuilt 2001 · S/N 1177N88ECPlane Company LLC · Greenbrier, TNBuilt 2001 · S/N 1195N891TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0051N892TTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 0052N89EMIntegra Aviation LLC · Amarillo, TXBuilt 1998 · S/N 0049N911AXGuardian Flight Holdings Inc · Fairbanks, AKBuilt 1997 · S/N 0021N911XAAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0132N911XBAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0154N911XGAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0157N911XHAir Med Services LLC · Lafayette, LABuilt 2000 · S/N 0161N911ZGGuardian Flight Holdings Inc · Fairbanks, AKBuilt 2001 · S/N 0164N913LSVintage Aero Collection Inc · Wilmington, DEBuilt 2000 · S/N 1136N91HRSweetsholdings LLC · Lewisville, TXBuilt 2001 · S/N 1239
Back to AD 2001-08-14 R1