Registered aircraft · 58

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:74-13-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:74-13-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:74-13-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:74-13-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:74-13-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:74-13-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.

N103BABemidji Aviation Services Inc · Bemidji, MNBuilt 1971 · S/N LD-435 N104BABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-235 N112MFMummy Mountain Med LLC · Paradise Valley, AZBuilt 1966 · S/N LP-37 N114MNSutton Aircraft Salvage LLC · Palmer, AKBuilt 1965 · S/N 1553-107 N117AGRegistered aircraftN-number assigned, not yet registeredS/N LP-20 N129HAHiller Aircraft Corp · Firebaugh, CABuilt 1975 · S/N HA3029 N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297 N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202 N135BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LD-68 N14FFK & L Agri Farms Inc · Adams, NEBuilt 1961 · S/N 560F-1107-31 N198JWGarrison William E · Nickerson, KSBuilt 1962 · S/N 680F-1132-75 N199WMJetstream Ltd · Powell, OHBuilt 1964 · S/N 1406-59 N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459 N2071MBudd Aircraft Enterprises Inc · Chesterfield, MOBuilt 1977 · S/N 28R-7837064 N222WLAirborne Solutions Group · Dayton, OHBuilt 1962 · S/N 560F-1243-53 N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74 N235PLTree Top Flyers LLC · Cookeville, TNS/N 10039C N273PAPantechnicon Aviation Ltd · Minden, NVBuilt 1973 · S/N 4155 N2828SSuburban Air Express Inc · Fairbanks, AKBuilt 1963 · S/N 1329-14 N290MPSuburban Air Express Inc · Fairbanks, AKBuilt 1965 · S/N 1535-104 N303HAirborne Solutions Group · Dayton, OHBuilt 1963 · S/N 1312-62 N309VSSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 1659-128 N385CGOwensboro Warehouse Leasing LLC · Owensboro, KYBuilt 1965 · S/N 1495-14 N401MGLeff William J · Dayton, OHBuilt 1965 · S/N 1527-29 N4177VWages Charles Braden · Dallas, TXBuilt 1999 · S/N 3257077 N41KVRockberry LLC · Wilmington, DEBuilt 1964 · S/N 1422-69 N5035ESuburban Air Express Inc · Fairbanks, AKBuilt 1968 · S/N 1764-147 N512CSR Scott Hoffman/Silverado Transportation LLC · Kalispell, MTBuilt 1977 · S/N 28R-7837048 N5189DRiverside Pipe LLC · Farmington, NMBuilt 2002 · S/N T18208142 N53264Van De Wall Allan · Oro Valley, AZBuilt 2001 · S/N 3257220 N55SABemidji Aviation Services Inc · Bemidji, MNBuilt 1965 · S/N LD-243 N6067HMilford Aviation Inc · Hoffman Estates, ILBuilt 1977 · S/N 28R-7837050 N6083HAerotyne Aviation LLC · Omaha, NEBuilt 1977 · S/N 28R-7837052 N6159HJeva Ventures LLC · Charleston, SCBuilt 1977 · S/N 28R-7837055 N6226DNielsen James R · Carson City, NVBuilt 1963 · S/N 1307-60 N6253XMoudy James D · Fairhope, ALBuilt 1961 · S/N 680F-1089-67 N6272XPrairie Aviation Museum Inc · Bloomington, ILS/N 680F-1159-83 N630TAN630ta Corp · Miami, FLBuilt 1962 · S/N 1214-112 N6350UWeatherbird Ltd · New York, NYRegistration revokedBuilt 1965 · S/N 1431-150 N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351 N6598LAtmospheric Corrosion Specialists Inc · Mechanicsburg, PABuilt 1969 · S/N 31-483 N680PLDw Educational Research Inc · Fowler, CABuilt 1961 · S/N 680F-969-27 N680RRNizex Inc · Jackson, GABuilt 1963 · S/N 1361-139 N6890QSoest Dean · Quartz Hill, CABuilt 1965 · S/N LD-224 N6AQNyerges James · Midland, TXBuilt 1964 · S/N LD-214 N742WAirborne Holdings Inc · Midlothian, TXBuilt 1966 · S/N 680FL-1650 N747VWHammer Aviation LLC · Miami, FLBuilt 1967 · S/N LD-360 N7502NBemidji Aviation Services Inc · Bemidji, MNS/N LD-391 N7817LNyerges James · Midland, TXBuilt 1967 · S/N LD-340 N800QACitadelle Holdings LLC · Palmetto Bay, FLBuilt 1962 · S/N LD-29

Back to AD 74-13-05