Skip to content

Registered aircraft · 174

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:2017-15-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:2017-15-13') 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:2017-15-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:2017-15-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.

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:2017-15-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:2017-15-13')
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.

N100WGTotal Helicopters Unlimited · Stafford, VAS/N 57341 N101JJStillwater Aviation LLC · Champaign, ILBuilt 2022 · S/N 57443 N102BFBell Textron Inc · Fort Worth, TXBuilt 2013 · S/N 57185 N111TDWaskey Realty LLC · Baton Rouge, LABuilt 2014 · S/N 57250 N124AMKeybank Na · Superior, COBuilt 2022 · S/N 57450 N142RCRc Aviation Services Inc · San Juan, PRBuilt 2022 · S/N 57441 N158DBPalm Beach County Sheriffs Office · West Palm Beach, FLBuilt 2015 · S/N 57292 N159PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57160 N165PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57163 N168PDAdministracion De Los Servicios Generales · San Juan, PRBuilt 2013 · S/N 57161 N16WWRegistered aircraftBuilt 2018 · S/N 57343 N174EMWest States Leasing Inc · Medford, ORBuilt 2020 · S/N 57387 N19UCCovenanter Investments III LLC · Nashville, TNBuilt 2012 · S/N 57068 N1SPState Of Delaware · Dover, DEBuilt 2013 · S/N 57184 N211FXCounty Of Fairfax · Fairfax, VABuilt 2010 · S/N 57004 N212FXCounty Of Fairfax · Fairfax, VABuilt 2011 · S/N 57055 N2274RHarrison Rosemary J · Houston, TXBuilt 2021 · S/N 57422 N227SWStedman West Interests Inc · Houston, TXS/N 57458 N24QTQuiktrip Corp · Tulsa, OKBuilt 2024 · S/N 57512 N255PDRegistration Pending · San Juan, PRRegistration pendingBuilt 2024 · S/N 57529 N26QTQuiktrip Corporation · Tulsa, OKS/N 57461 N280KWTennessee Department Of Safety & Homeland Security · Nashville, TNBuilt 2024 · S/N 57516 N285SPKentucky State Police · Frankfort, KYBuilt 2025 · S/N 57546 N2891Sarasota County Sheriffs Office · Sarasota, FLBuilt 2024 · S/N 57499 N28BBCove Partners LLC · Santa Monica, CAS/N 57327 N29MJAir Methods LLC · Greenwood Village, COBuilt 2021 · S/N 57423 N2AFRegistered aircraftBuilt 2018 · S/N 57354 N2GSRegistered aircraftBuilt 2013 · S/N 57152 N2SPState Of Delaware · Middletown, DEBuilt 2024 · S/N 57511 N305HFHonolulu Fire Department · Honolulu, HIBuilt 2024 · S/N 57517 N308GRBell Textron Inc · Fort Worth, TXS/N 57549 N309GRBell Textron Inc · Fort Worth, TXS/N 57561 N312GRBell Textron Inc · Fort Worth, TXS/N 57563 N317GRBell Textron Inc · Fort Worth, TXS/N 57564 N318GRBell Textron Inc · Fort Worth, TXS/N 57567 N323GRBell Textron Inc · Fort Worth, TXS/N 57569 N324FDTotal Helicopters Unlimited · Stafford, VABuilt 2018 · S/N 57346 N3251RTeledyne Flir Defense LLC · Wilsonville, ORBuilt 2018 · S/N 57359 N326GRRegistered aircraftN-number assigned (import), not yet registeredS/N 57577 N32FEAmerican Transmission Systems Inc · Akron, OHBuilt 2021 · S/N 57416 N334ECEntergy Services LLC · New Orleans, LABuilt 2025 · S/N 57540 N34FEMid-Atlantic Interstate Transmission LLC · Akron, OHBuilt 2021 · S/N 57420 N34UTUnited Therapeutics Corp · Res Triangle Park, NCBuilt 2015 · S/N 57265 N357FWFlorida Fish And Wildlife Conservation Commission · Lakeland, FLS/N 57312 N357RBBell Textron Inc · Fort Worth, TXS/N 57559 N35RHHms Holdings LLC · Charlotte, NCBuilt 2011 · S/N 57035 N394BHOld West Aviation LLC · Brighton, MIBuilt 2024 · S/N 57526 N399BTBell Textron Inc · Fort Worth, TXS/N 57013 N401NCNorth Carolina State Highway Patrol · Cary, NCBuilt 2022 · S/N 57457 N411CEUS Bank Na · Marshall, MNBuilt 2019 · S/N 57370

Back to AD 2017-15-13