Registered aircraft · 246

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

N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N109AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11078 N109ALEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11113 N109BMRegistration Pending · North Salt Lake, UTRegistration pendingS/N 11157 N109BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22055 N109CGEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11109 N109DDLitton Global LLC · Wilmington, DEBuilt 2000 · S/N 11069 N109DRBristow LLC · Lake Charles, LAS/N 31311 N109FBCity Of Phoenix · Phoenix, AZS/N 11629 N109HNPrestige Air LLC · Aliso Viejo, CABuilt 2000 · S/N 11087 N109MHGateway Air Center Inc · Merced, CABuilt 1998 · S/N 11026 N109PPhoenix Helicopters LLC · Dover, DES/N 11035 N109SJCarmona Cristobal Pelaez · Laredo, TXS/N 11170 N109TGTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 2006 · S/N 11680 N10BLLeon Helicopter One LLC · Miami, FLBuilt 2009 · S/N 22105 N116TGLeonardo Helicopters US Corp · Philadelphia, PAS/N 41630 N118JMMjm Aviation LLC · Piscataway, NJBuilt 2010 · S/N 41251 N119MWBristow LLC · Lake Charles, LABuilt 2012 · S/N 41307 N122TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 11221 N126JJFci Aeronautics LLC · Marble Falls, TXBuilt 2009 · S/N 11741 N129ALNiihau Helicopters Inc · Makaweli, HIS/N 10029 N129ARAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 11125 N12MQArrow Aviation Company LLC · Broussard, LAS/N 31041 N139Eurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2009 · S/N 31229 N1392CRegistered aircraftBuilt 2025 · S/N 41602 N139AKTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 41565 N139BAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41628 N139DERegistered aircraftBuilt 2013 · S/N 41334 N139EXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31851 N139FWChevron USA Inc · Picayune, MSBuilt 2005 · S/N 31022 N139HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2007 · S/N 31101 N139HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 31021 N139HSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2005 · S/N 31016 N139PHPhi Aviation LLC · Lafayette, LAS/N 41253 N139TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41409 N139WTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 41612 N140EVSuperior Aviation Solutions LLC · Mooresville, NCBuilt 2005 · S/N 31025 N140PHPhi Aviation LLC · Lafayette, LABuilt 2010 · S/N 41254 N141PHPhi Aviation LLC · Lafayette, LAS/N 41266 N146PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 41280 N149DHEra Leasing LLC · Houston, TXBuilt 2007 · S/N 41004 N149PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41303 N151PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41312 N152PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41316 N153PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41317 N15460Variety Childrens Hospital DBA · Miami, FLBuilt 2012 · S/N 41323 N156JSEra Leasing LLC · Lake Charles, LABuilt 2007 · S/N 41003 N159RBBristow LLC · Lake Charles, LABuilt 2012 · S/N 41281 N181JPowderbird LLC · Providence, RIBuilt 2018 · S/N 41544 N197JGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 2004 · S/N 11616

Back to AD 2025-03-03