Registered aircraft · 744

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

N308RMN308rm LLC · Boca Raton, FLBuilt 1974 · S/N LJ628 N30KCSkillman Management LLC · Wellington, FLBuilt 1977 · S/N LW-241 N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313 N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113 N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461 N314MRMiller Aviation LLC DBA · Huntington, INBuilt 1976 · S/N LW-184 N316GCMarc Aircraft Holding LLC · Soldotna, AKBuilt 1978 · S/N BB-430 N31WCPro Serve Aviation LLC · Englewood, COBuilt 1979 · S/N BB-465 N31WPSale Reported · Gaylord, MISale reported, pending cancellationBuilt 1974 · S/N LW-99 N321DZNardi Greg · Missoula, MTBuilt 1968 · S/N LJ-367 N321FDynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-70 N322RN322r LLC · St Simons Island, GABuilt 1977 · S/N LJ-746 N323HADale Aviation Inc · Rapid City, SDBuilt 1979 · S/N LW-323 N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396 N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553 N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99 N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335 N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548 N32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PABuilt 1969 · S/N LJ-475 N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865 N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456 N330VAlcovy Mountain Venture LLC · Monroe, GABuilt 1978 · S/N LJ-811 N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816 N332DEMetro Aircraft Co · Bloomington, MNBuilt 1975 · S/N LJ-674 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N333TLBrad And Jill Janecke LLC · Pierre, SDBuilt 1982 · S/N LJ-999 N335TAN335ta LLC · Anchorage, AKBuilt 1979 · S/N BB-514 N339KAChenango Aviation LLC · Dallas, TXBuilt 1980 · S/N LW-339 N33FRCharles L Fridge III Pc · Houston, TXBuilt 1978 · S/N LW-299 N343KKTreeline Transportation Inc · Vance, ALBuilt 1978 · S/N BE-46 N34CEFirst Call Home Health Agency LLC · Salem, ORBuilt 1981 · S/N LJ-932 N34MFDavis Aviation Inc · Brandon, MSBuilt 1975 · S/N LW-163 N34UPCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N BC-006 N350TCFobl Inc · Juana Diaz, PRBuilt 1979 · S/N BE-62 N351GRDodson International Parts Inc · Rantoul, KSS/N LW-324 N3532North Delta Ag Aviation LLC · Sledge, MSBuilt 1977 · S/N BE-31 N3536Vantage Aviation USA LLC · Tampa, FLBuilt 1979 · S/N BE72 N3538New Mountain Aviation LLC · Englewood, COBuilt 1978 · S/N BE-57 N3539Thacker Aircraft Holding LLC · Lubbock, TXBuilt 1982 · S/N BE-124 N35BAC90 Air Inc · Lemoore, CABuilt 1980 · S/N LJ-909 N35CVNavajo Enterprises LLC · Schwenksville, PABuilt 1977 · S/N LW-252 N35TVN35tv LLC · Shawnee, OKBuilt 1972 · S/N LJ-572 N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30 N360BLBachman Aviation LLC · Independence, IAS/N BE17 N361KABehrens Investments Of Wisconsin LLC · Waukesha, WIBuilt 1980 · S/N BB-741 N362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N LJ760 N366GWK&K Leasing Inc · Tea, SDBuilt 1979 · S/N LW-320 N3690FWv Gastro & Endo LLC · Wheeling, WVBuilt 1980 · S/N LJ-921 N3695WSuarez-Ballardo Jorge Luis · Glendale, AZBuilt 1980 · S/N LJ-924 N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291

Back to AD 80-09-03 R1