Skip to content

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.

N444TVScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3501 N4452Bravo Aviation LLC · Chicago, ILBuilt 1973 · S/N 1086 N445AEAir Evac Ems Inc · O'Fallon, MOBuilt 2013 · S/N 52452 N445LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56355 N445PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54096 N445SLAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 53445 N446JBFinish Line Aviation LLC · Pembroke, NHS/N 45411 N447AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52454 N447BFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 54447 N447GHGuardian Helicopters Inc · Fillmore, CABuilt 1997 · S/N 53213 N447JBJbi South Leasing LLC · Pembroke, NHBuilt 1980 · S/N 45415 N447LXSafe Aviation Leasing LLC · Lakeland, FLBuilt 2025 · S/N 56447 N448EAEdgefield Aviation LLC · Sandy, ORBuilt 1974 · S/N 1495 N448LFLife Flight Network LLC · Aurora, ORS/N 56359 N448PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54111 N449EAEdgefield Aviation LLC · Sandy, ORBuilt 1982 · S/N 51027 N449LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56360 N449PPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 1997 · S/N 53209 N449PHPhi Health LLC · Tempe, AZBuilt 2012 · S/N 54117 N449SS & L Farm And Ranch LLC · Georgetown, TXBuilt 1998 · S/N 4495 N44APBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 54316 N44BCRiggs Rock A · Lake Mary, FLBuilt 1976 · S/N 1904 N44HCRecon Holdings LLC · Union, MIBuilt 1997 · S/N 53164 N44HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53125 N450AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54435 N450LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56352 N450PHPhi Health LLC · Tempe, AZBuilt 2012 · S/N 54125 N451LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56384 N452LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56380 N452MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1995 · S/N 4377 N452PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 53568 N452PHPhi Aviation LLC · Lafayette, LABuilt 2000 · S/N 53457 N453LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56382 N453PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53266 N453RPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2003 · S/N 53572 N453RARanger Aviation Leasing LLC · Wilmington, DEBuilt 1981 · S/N 3453 N453RRJetbird Aviation LLC · Conroe, TXBuilt 2007 · S/N 52356 N454AEAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 52460 N454MSCb Couch Inc · Walcott, ARBuilt 1975 · S/N 1627 N454NCStraight Up Leasing Inc · Medford, ORBuilt 1999 · S/N 53382 N454PHPhi Aviation LLC · Lafayette, LABuilt 2000 · S/N 53435 N455LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56418 N455NCStraight Up Leasing Inc · Medford, ORBuilt 2009 · S/N 53941 N455PDCharlotte Mecklenburg Police Department · Charlotte, NCBuilt 2021 · S/N 54926 N455TVCox Paul G DBA · Bryce, UTS/N 2796 N4569U S Army · Ft Rucker, ALBuilt 2006 · S/N 5306 N456KBPurdy Ranch LLC · Buffalo, WYBuilt 1997 · S/N 53133 N456LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56416 N457LFLife Flight Network LLC · Aurora, ORBuilt 2015 · S/N 54592 N457MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 53974

Back to AD 2013-22-21