Registered aircraft · 2,382

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

N925MDAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 53477 N925MFMaine Department Of Agriculture Conservation · Old Town, MEBuilt 2008 · S/N 53836 N925SPGeorgia Department Of Public Safety · Kennesaw, GABuilt 2008 · S/N 53893 N927AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54601 N928CMHillsboro Aviation Inc · Hillsboro, ORBuilt 1999 · S/N 53384 N928LAExecutive Helicopters LLC · El Centro, CABuilt 1981 · S/N 3371 N9290ZMaco Aviation Inc · Dayton, WABuilt 1978 · S/N 2452 N929BTBell Textron Inc · Fort Worth, TXS/N 54929 N929KCAerotrust Services Corp Trustee · Wilmington, DES/N 3605 N92JPCity Of Jacksonville Sheriffs Office · Jacksonville, FLBuilt 2020 · S/N 54934 N92NHelicopters Inc · Cahokia, ILBuilt 1997 · S/N 53093 N92NHNorth Shore University Hospital · Manhasset, NYBuilt 2024 · S/N 56425 N92PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1981 · S/N 3402 N92PJWw Flying Services LLC · Waller, TXBuilt 1984 · S/N 51094 N930SPGeorgia Department Of Public Safety · Kennesaw, GABuilt 2007 · S/N 53760 N932SFN390sf LLC · Chandler, AZBuilt 2005 · S/N 53653 N933TGBuckeye Leasing LLC · Shreveport, LABuilt 2012 · S/N 54376 N936PSLindsey Aviation Services · Haslet, TXBuilt 2005 · S/N 53654 N93BHBlue Hill Helicopters LLC · Norwood, MABuilt 1995 · S/N 5216 N93DDHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53030 N93LLHelicopters Inc · Linden, NJBuilt 1997 · S/N 4458 N93MKDel Rio Aviation Inc · Paso Robles, CABuilt 1972 · S/N 867 N93MPMissouri State Highway Patrol · Jefferson City, MOBuilt 2006 · S/N 53744 N93PHProvine Helicopter Service Inc · Greenwood, MSS/N 2688 N941AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54594 N941JVParagon Air Group · Fort Worth, TXBuilt 2008 · S/N 53911 N941SCHover One LLC · Lucas, TXBuilt 1974 · S/N 1497 N941SHSummit Helicopters Inc · Salem, VABuilt 1998 · S/N 52205 N944HHillcrest Aircraft Co · Lewiston, IDS/N 53122 N944TGMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 54377 N945RFCharm Aviation Heli I LLC · Windham, NHBuilt 2015 · S/N 54581 N946BWMinuteman Aviation Inc · Missoula, MTS/N 3962 N946CBRhl Aviation LLC · Montrose, PABuilt 2011 · S/N 52427 N946MBemer Aviation Inc · Glastonbury, CTBuilt 1982 · S/N 3646 N947LHExecutive Air Taxi Corp · Bismarck, NDBuilt 2001 · S/N 53509 N947MDAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 53569 N94ECHelicopter Air Transport Service Inc · Lynchburg, VAS/N 3200 N94HPPila LLC · Heber City, UTBuilt 1999 · S/N 52218 N94VMMachugh David · Pasco, WABuilt 1994 · S/N 4316 N94XAXtreme Aviation LLC · Falkville, ALBuilt 1994 · S/N 5131 N953AZRight Brother Aviation LLC · Chaffee, NYBuilt 1996 · S/N 4404 N953GMLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53720 N954TJTx Investments LLC · Fort Lauderdale, FLBuilt 2002 · S/N 4567 N955TGMetro Aviation Inc · Shreveport, LABuilt 2012 · S/N 54379 N956AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54597 N958TRStraight Up Leasing Inc · Medford, ORBuilt 2007 · S/N 53770 N959LPPanther Helicopters Inc · Belle Chasse, LABuilt 2006 · S/N 53690 N95ALLakeland Aircraft Maintenance LLC · Eagle Lake, FLBuilt 1990 · S/N 51360 N95MPMissouri State Highway Patrol Aircraft Division · Jefferson City, MOS/N 56324 N95PDBeck Aviation LLC · Fort Myers, FLBuilt 1998 · S/N 52206

Back to AD 2013-22-21