Registered aircraft · 7,430

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

N1002XMd Helicopters LLC · Mesa, AZS/N 0362FF N1004RMd Helicopters LLC · Mesa, AZS/N 0363FF N1004TI1 Aviation LLC · Ronkonkoma, NYBuilt 2010 · S/N 13012 N1005GMd Helicopters LLC · Mesa, AZS/N 0364FF N1006CMd Helicopters LLC · Mesa, AZS/N 0365FF N1006MMd Helicopters LLC · Mesa, AZS/N 0366FF N1006TMd Helicopters LLC · Mesa, AZS/N 0367FF N1007GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9164 N1008HMd Helicopters LLC · Mesa, AZS/N 0369FF N100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718D N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2025 · S/N 2291 N100KRJjj Holdings LLC · Eugene, MOBuilt 2025 · S/N 1458 N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992 N1019VQualitair LLC Trustee · MichelstadtS/N 1353 N101AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45454 N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N101GD101 Gd Corp · Miami, FLBuilt 2021 · S/N 14434 N101HFAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 53463 N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123 N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N101SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14728 N101TVSky Helicopters Inc · Garland, TXBuilt 1998 · S/N 0475 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250 N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391 N1028SSt Johns County Sheriffs Office · Saint Augustine, FLBuilt 2013 · S/N 54405 N102AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54721 N102AFMjm Enterprises LLC · Wilmington, DEBuilt 2007 · S/N 1779 N102AJBird Dog Aircraft LLC · Billings, MTS/N 7868 N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85 N102CQChatham County · Savannah, GABuilt 1999 · S/N 0901FF N102CVPilot In Command LLC · Parker, COBuilt 1999 · S/N 0570 N102HNAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 0159 N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671 N102SUSignature Property Holdings LLC · Wilmington, DES/N 700736D N102SWGeorgia Helicopter Leasing Corp · Douglasville, GABuilt 2012 · S/N 0106 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N103AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45597 N103CGCity Of Burbank · Burbank, CABuilt 2006 · S/N LN102 N103HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39125 N103JPCity Of Jacksonville Sheriffs Office · Jacksonville, FLBuilt 2021 · S/N 54946 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N103NJUsda Forest Service Fepp · Trenton, NJBuilt 1969 · S/N 361 N103VUAir Methods LLC · Greenwood Village, COS/N 9054 N104AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54733 N104APRock Creek Leasing LLC · Sapulpa, OKBuilt 1990 · S/N 4149 N104EGSpitzer Helicopter LLC · Wilmington, DEBuilt 2013 · S/N 2266 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094

Back to AD 2024-20-07