Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N22120Big Red Aerobatics LLC · Lewes, DEBuilt 2000 · S/N 60 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N2212ASiewart Michael · Columbus, OHS/N 310G-0018 N2212DMichel David L · Greenville, SCBuilt 1973 · S/N 28R-7335443 N2212PHollingshead Terry L · Flint, MIS/N 23-821 N2212RFlystar Aviation LLC · Tampa, FLBuilt 1969 · S/N 28-5485 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074 N22132Mile High Aviation LLC · Pahrump, NVS/N 0001 N2213AShort Colton R · Force, PABuilt 1952 · S/N 20-897 N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513 N2213FJ & M Airways LLC · Troy, MIBuilt 1978 · S/N 28-7911050 N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513 N2213MWeels Up Inc · Pasadena, CABuilt 1979 · S/N 28-7911092 N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514 N2214DLillian Aviation LLC · Cypress, TXBuilt 1978 · S/N 28-7911036 N2214FSky Financial Services Inc · Center Valley, PABuilt 1978 · S/N 32R-7985042 N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514 N2214LBlue Bird Aviation LLC · San Jose, CABuilt 2005 · S/N 18281718 N2214MWings Flying Club Inc · South Bend, INBuilt 1977 · S/N 28-7890234 N2214PMaslen Holbrook · Caldwell, IDS/N 23-823 N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014 N2215LCasey James Kelton · Galveston, TXBuilt 1977 · S/N M-1868 N2215PTzenis Michael · Lakeville, MNBuilt 1956 · S/N 23-824 N2215QMoore Verba A · Biloxi, MSBuilt 1979 · S/N 28R-7918054 N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367 N2215YNaran Ashish H · Brookhaven, GABuilt 2000 · S/N 30-0049 N2215ZAjb Holdings LLC · Rock Hill, SCBuilt 1979 · S/N 28-7990406 N22166Reading Jared T · Uvalde, TXBuilt 2000 · S/N 29-0225 N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516 N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504 N2216KRugged Country Helicopters LLC · Cedar City, UTBuilt 1989 · S/N 0998 N2216URegistered aircraftBuilt 1974 · S/N U20602355 N2216YPacific Union College · Angwin, CABuilt 1979 · S/N 44-7995290 N22175Johnson Richard E · Duluth, MNBuilt 1978 · S/N 28-7916062 N22177Gedney Douglas Kevin · Grand Haven, MIBuilt 1976 · S/N 177-02323 N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230 N2217DDaytona Jets LLC · Daytona Beach, FLBuilt 1978 · S/N 44-7995137 N2217EBaughman Thomas · Napoleon, OHBuilt 1978 · S/N 32R-7985039 N2217KRoss Mitchell B · Ledyard, CTBuilt 1978 · S/N 28-7916226 N2217LInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 18281674 N2217RParke Mike D · Twin Falls, IDBuilt 1968 · S/N T210-0367 N2217TTango LLC · Anchorage, AKBuilt 1968 · S/N 185-1369 N2217YLehmer Kenneth D Trustee · Pls Vrds Est, CABuilt 1959 · S/N D-6056 N22184Rosene Richard W · Newport, RIBuilt 2000 · S/N 29-0227 N2218CMart Gary A · Bend, ORS/N 30518 N2218LEldib Ramsey C · Malibu, CAS/N MB-817 N2218MBerry Jeffrey M · Palmetto Bay, FLBuilt 2000 · S/N 30-0050 N2218SBaldridge Buddy · Snyder, TXBuilt 1979 · S/N 32-7940057

Back to AD 2007-04-19 R1