Registered aircraft · 611

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

N100LMHaddock Flying Service Inc · Salters, SCS/N 1583 N101ALRegistered aircraftBuilt 1980 · S/N U20605684 N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829D N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045 N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85 N102UMTimberland Helicopters Inc · Ashland, ORBuilt 1981 · S/N 5075 N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062 N105HHHaddock Flying Service Inc · Salters, SCS/N 1307 N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105 N105LCCenterline Holdings Inc · Camden, DEBuilt 1988 · S/N S789 N105SUSignature Property Holdings LLC · Wilmington, DEBuilt 1988 · S/N 800776D N1075WSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 45377 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N107GGCarbon River Helicopter Services LLC · Lexington, KYBuilt 1980 · S/N 2917 N107PHSouthern Helicopter Service Inc · Millington, TNBuilt 1979 · S/N 2789 N1081KMarks Aviation Group LLC · Lafayette, LABuilt 1980 · S/N 45407 N109CYO'Brien Derrick P · Middletown, DES/N 7351 N109MMAirborne Leasing Inc · Sylmar, CABuilt 1985 · S/N 7279 N109PBBennedsen Rosa Fadia Gabriel · Aventura, FLBuilt 1985 · S/N 7344 N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164 N109XPNational Test Pilot School · Mojave, CABuilt 1981 · S/N 7178 N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169 N10JSSiegel Jerry S · Los Angeles, CAS/N 008 N10KXWhirly Leasing Inc · Richvale, CABuilt 1975 · S/N 1628 N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403 N113RLMarks Aviation Group LLC · Lafayette, LABuilt 1981 · S/N 3306 N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N1158BAir Gov 1 LLC · Rome, NYBuilt 1996 · S/N 4431 N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N117HKSettan Corp · Goleta, CABuilt 1997 · S/N 4462 N118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1991 · S/N 4182 N118TVInterstate Helicopter Inc · Bethany, OKBuilt 1979 · S/N 2844 N11FHD H Helicopter Inc DBA · Sauget, ILBuilt 1993 · S/N 4270 N11ZXBig Bird Leasing Inc · Saint Peter, MNBuilt 1974 · S/N 640609S N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819 N1219WMoes Crop Dusting Service Inc · Marysville, CABuilt 1975 · S/N 1843 N123NMAglk LLC · Lewes, DES/N 6702 N124EHJbp Aviation LLC · Henderson, NVS/N S559 N124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502E N126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489E N12AAAllsouth Aviation LLC · Buford, GABuilt 1996 · S/N 52165 N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003 N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069 N12THHarding Tim · Bryan, TXS/N 0224E N130BHObrien Helicopters Inc · Lehigh Acres, FLBuilt 1975 · S/N 1776 N130JHRanger Aviation Leasing LLC · Wilmington, DES/N 4166 N131AEAtwood Aviation LLC · Pickerington, OHBuilt 1988 · S/N S787

Back to AD 93-25-05