Registered aircraft · 25,370

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-25-07-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-25-07-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-25-07-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-25-07-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-25-07-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-25-07-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.

N19411Taylor Fred H · Plano, TXFirst renewal noticeBuilt 1969 · S/N 690085 N19419Dean Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 17702570 N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296 N1943QLeonard Joseph · Bohemia, NYBuilt 1973 · S/N 177RG0343 N19445Scott Beau · Ashville, OHBuilt 1976 · S/N 17702572 N1944QHenry Peter S · Olympic Valley, CABuilt 1973 · S/N 177RG0344 N1944YHolcombe Thomas Hg · Moss, TNBuilt 1964 · S/N 251 N1945FLake Elmo Aero LLC · Lake Elmo, MNBuilt 1979 · S/N 17273035 N1945QSmith Thomas E Jr · Chino Hills, CABuilt 1973 · S/N 177RG0345 N1946QMoore Garrie W · Georgetown, TXBuilt 1973 · S/N 177RG0346 N1946YTrimmer Benjamin M · Tomball, TXBuilt 1964 · S/N 253 N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037 N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347 N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564 N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038 N1948QHorsley Luther J · Midland, ORS/N 177RG0348 N1948YGregory Michael Rybarczyk · West Chester, OHBuilt 1964 · S/N 255 N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835 N1949YHawkins Robert A · Lake Butler, FLBuilt 1964 · S/N 256 N194AMFields Douglas P Jr · Saranac Lake, NYBuilt 1994 · S/N 729-94 N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029 N194BAUnruly Passengers LLC · Piedmont, SCS/N 38-82A0063 N194BCAircraft Investments LLC · Ketchum, IDBuilt 2006 · S/N 489-2006 N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386 N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574 N1950DHorney Paul · Russellville, ARBuilt 2020 · S/N 1476-2020 N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040 N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350 N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575 N1951EMcclure Steve · Lebanon, INBuilt 1968 · S/N 81 N1952YVess Derek Wayne · Kempner, TXBuilt 1964 · S/N 259 N1953YDavid Michael B · Miami Beach, FLBuilt 1964 · S/N 260 N1954SBarca Sky F · Simi Valley, CABuilt 1974 · S/N 17702197 N1954VBray Aviation LLC · Calera, OKBuilt 1974 · S/N 17263803 N1954YSasse David L · Rio Rancho, NMS/N 2691 N1955VJd Kracl Aircraft LLC · Gretna, NEBuilt 1974 · S/N 17263804 N1955YBeckworth Willis S · Gonzales, LABuilt 1964 · S/N 262 N1956FPenzo Michael A · Stafford, VABuilt 1979 · S/N 17273046 N1956HWalker Benjamin R · Brasstown, NCBuilt 2012 · S/N 1466-2012 N1957Registered aircraftBuilt 1977 · S/N 17269009 N19575Galis Iuri · Oklahoma City, OKBuilt 1976 · S/N 17702577 N1957FSteward Ashtyn L · Weatherford, TXBuilt 1979 · S/N 17273047 N1958BSale Reported · Champaign, ILSale reportedBuilt 1973 · S/N 17261839 N19600Corona Police Aero Squadron Inc · Calimesa, CABuilt 1972 · S/N 17260600 N19601Pnl Aviation LLC · Brunswick, MEBuilt 1972 · S/N 17260601 N19602Lucas Mitchell H · Jackson, GABuilt 1972 · S/N 17260602 N19603Stanly Business Consultants LLC · Albemarle, NCBuilt 1972 · S/N 17260603 N19606Stettner George J · Spring Hill, FLBuilt 1972 · S/N 17260605 N19609Johnson Erik S · Navarre, FLBuilt 1972 · S/N 17260607 N1960FCornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1979 · S/N 17273050

Back to AD 80-25-07 R1