Registered aircraft · 1,642

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-18-13') 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-18-13') 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-18-13')
    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-18-13')
  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-18-13')
  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-18-13')
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.

N2205ULighter Aaron S · Buckeye, AZBuilt 1979 · S/N 32-7940064 N2209TSngdo Aviation LLC · Spring Hill, FLBuilt 1971 · S/N 32-7140070 N2218SBaldridge Buddy · Snyder, TXBuilt 1979 · S/N 32-7940057 N2220JTrj Aero Holdings LLC · Tequesta, FLBuilt 1978 · S/N 32-7940008 N2225SAshland Aviation LLC · Ashland, OHBuilt 1979 · S/N 32-7940058 N22262Oldenkamp David J · Payson, AZBuilt 1978 · S/N 32-7840191 N2227JAldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7940010 N2229JKaiser Hayward J · Los Angeles, CABuilt 1978 · S/N 32-7940011 N222GESmith Daniel J · Mcmurray, PABuilt 1975 · S/N 32-7500020 N222JLThomas Kent C · Muncie, INBuilt 1973 · S/N 32-7340135 N2231MGreat Lakes Aviation Services Inc · Kimball, MIS/N 32-975 N2233LBecker Leo Henry · Leavenworth, KSBuilt 1979 · S/N 32-7940028 N223MDPremier Engineering Inc · San Antonio, FLBuilt 1974 · S/N 32-7440154 N2242ZN2242z LLC · Newtown, CTBuilt 1979 · S/N 32-7940114 N2244ZGood Timothy · Waxhaw, NCBuilt 1979 · S/N 32-7940110 N2265QMyl High Flying Club LLC · Mccall, IDS/N 32-7740048 N227RFHouser Harry David Jr · Williamstown, WVBuilt 1972 · S/N 327200045 N22DTMartin Communications Inc · West Monroe, LABuilt 1975 · S/N 32-7640033 N232CASawdust Aviation Inc · Bellefonte, PABuilt 1976 · S/N 32-7740026 N234TAGilk Timothy H Trustee · Redwood Falls, MNBuilt 1978 · S/N 32-7840119 N2351MGot My Six LLC · Lewes, DES/N 32-7840047 N235CMReed Michael · Chino Hills, CAS/N 32-786 N2391UJeffway Robert W Jr · Leeds, MABuilt 1979 · S/N 32-7940253 N23LAWill Voyles Farms LLC · Wynne, ARS/N 32-7840045 N23MMAmerica Atlantic Aviation Inc · Stuart, FLBuilt 1967 · S/N 32-40367 N242EBEb Marine LLC · Riviera Beach, FLBuilt 1967 · S/N 32-40229 N242EX242ex LLC · West Palm Beach, FLS/N 32-7940234 N242KMPlane Care Inc · Weston, FLBuilt 1977 · S/N 32-7740111 N2461MAbdulla Urooj · Damon, TXBuilt 1977 · S/N 32-7840049 N2507QGift Arthur D Trustee · Wanatah, INBuilt 1977 · S/N 32-7740050 N250WAWelch Eric · Lakeland, TNBuilt 1978 · S/N 32-7840102 N254MVFlight World Inc · San Juan, PRBuilt 1965 · S/N 32-117 N255KHSmith Steward Joseph · Reno, NVBuilt 1973 · S/N 327340114 N256SGCalache Michael · Fredon, NJBuilt 1976 · S/N 32-7640094 N257DLN T M A Holdings LLC · Lewes, DEBuilt 1975 · S/N 32-7540141 N257SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 32-40755 N260BBDutchess Community College Foundation · Poughkeepsie, NYS/N 32-7400045 N260CSRegistration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1975 · S/N 32-7500022 N260FHFlorida Flyers · Jacksonville, FLBuilt 1965 · S/N 32-54 N260GPJs Doig Restoration LLC · Varnville, SCBuilt 1967 · S/N 32-873 N260SWMattson Krister T · Onalaska, WIBuilt 1966 · S/N 32-541 N260WGRegistered aircraftBuilt 1968 · S/N 32-1039 N2617MBarrett Gaston W DBA · Philadelphia, MSBuilt 1977 · S/N 32-7840051 N261RSNational Aviation Partners LLC · Weatherford, TXBuilt 1972 · S/N 32-7340056 N2659TLeja Surveying Corp · Yucaipa, CABuilt 1971 · S/N 32-7240036 N267RBLearn To Fly LLC · Portal, GABuilt 1967 · S/N 32-40261 N26DCAce Aviation LLC · Reading, VTBuilt 1965 · S/N 32-64 N26LS J D H LLC · Sewickley, PABuilt 1969 · S/N 32-40877 N271MDDismore Matthew · Gulfport, MSBuilt 1979 · S/N 32-7940232 N273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138

Back to AD 74-18-13