Registered aircraft · 2,857

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

N1007GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9164 N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N100WGTotal Helicopters Unlimited · Stafford, VAS/N 57341 N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123 N101JJStillwater Aviation LLC · Champaign, ILBuilt 2022 · S/N 57443 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250 N1022QAmerican Huey 369 Inc · Peru, INBuilt 1964 · S/N 64-14049 N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391 N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868 N102BFBell Textron Inc · Fort Worth, TXBuilt 2013 · S/N 57185 N102FWSierra Aeronautics LLC · Franklin, KYS/N 62-1905 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N10432Huey 197 LLC · Argyle, TXBuilt 1968 · S/N 68-16197 N1043TCroman Corp · White City, ORBuilt 1961 · S/N 61083 N1044QReynolds Darryl G · Wills Point, TXS/N 66-17100 N1048YCroman Corp · White City, ORBuilt 1961 · S/N 61161 N104HFArmy Aviation Heritage Foundation · Hampton, GABuilt 1968 · S/N 68-16104 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N105NJUsda Forest Service Fepp · Trenton, NJS/N 66-17071 (9265)N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N106CPSouthwest Florida Aviation Inc · Arcadia, FLS/N 1170 N106NJUsda Forest Service Fepp · Trenton, NJS/N 66-16030 (5724)N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 N107CHAirlift Helicopters Services · Seal Beach, CABuilt 1967 · S/N 67-17290 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N107NJUsda Forest Service · Trenton, NJS/N 13682 N1081CCelebrate Freedom Foundation Inc · West Columbia, SCBuilt 1973 · S/N 73-21685 N108LNAir Methods LLC · Greenwood Village, COS/N 3959 N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080 N108VUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0509 N109AGO'Brien Helicopters Inc · Lehigh Acres, FLBuilt 1989 · S/N 7602 N109AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11078 N109ALEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11113 N109AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 22223 N109BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 1999 · S/N 0139 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 N109CYO'Brien Derrick P · Middletown, DES/N 7351 N109DDLitton Global LLC · Wilmington, DEBuilt 2000 · S/N 11069 N109DRBristow LLC · Lake Charles, LAS/N 31311 N109FBCity Of Phoenix · Phoenix, AZS/N 11629 N109GLA Air Club LLC · Tampa, FLBuilt 1990 · S/N 7623 N109HNPrestige Air LLC · Aliso Viejo, CABuilt 2000 · S/N 11087 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995

Back to AD 2022-05-10