Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021 N818YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 30-1458 N8190SAthar Glenola LLC · Mars, PABuilt 1982 · S/N 34-8233121 N8191LAlton Aviation LLC · Daytona Beach, FLS/N 34-8070192 N8191MWalters Larry C · Wasilla, AKBuilt 1964 · S/N 310I0191 N8192YPlane Fun Inc Tr Trustee · Snellville, GABuilt 1966 · S/N 30-1309 N8194RHouse Of J Inc · Lake Charles, LABuilt 1974 · S/N TC-1763 N8195MPeed Robert M · Gilbert, AZBuilt 1964 · S/N 310I0195 N8195QD&M Enterprise LLC · Wilmington, DEBuilt 1970 · S/N 414-0095 N8195ZWilliams Jason A · Cypress, TXS/N 34-8070212 N8197YTyer Larry E Jr · Newnan, GABuilt 1966 · S/N 30-1316 N8198YRoss Brian L · Eagle River, WIBuilt 1966 · S/N 30-1317 N819ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496538 N819MMPremier Aero LLC · Gonzales, LABuilt 1981 · S/N TC-2401 N819PDVah Aircraft Sales LLC · Pompton Beach, NJS/N 34-8070048 N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522 N819RKWheels Up Aviation II Inc · Arlington Heights, ILBuilt 1977 · S/N 34-7770347 N819SWWho Dey LLC · Savannah, GABuilt 1981 · S/N 31T-8104059 N81ABAcceler8 Aviation LLC · Livermore, CABuilt 1969 · S/N TC1247 N81AGDuke Transportation LLC · Idaho Falls, IDFirst renewal noticeBuilt 1973 · S/N P-219 N81AJAircraft Propulsion Leasing LLC · Holland, OHBuilt 1976 · S/N TK-12 N81AWSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 34-8133107 N81CLGlassman Aaron · Virginia Beach, VABuilt 1981 · S/N TH-1296 N81CNColumbia Aircraft Inc · Columbia, SCBuilt 1981 · S/N 34-8133110 N81DDJdj Transport LLC · Wilmington, DEBuilt 1980 · S/N TH-1212 N81DRCommonwealth Aviation Service Inc DBA · Richmond, VABuilt 1978 · S/N TH-971 N81DZAcceler8 Aviation LLC · Livermore, CABuilt 1978 · S/N 34-7870325 N81EDNav-Pete LLC · Memphis, TNBuilt 1979 · S/N 31-7952220 N81HCSmith Ronald Shane · Peachtree City, GABuilt 1990 · S/N TH-1600 N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083 N81MDTt Twins LLC · Fayetteville, GABuilt 1964 · S/N 30-512 N81MSCapital Craft LLC · Wilmington, DES/N 31T-8104007 N81NNNona Tech LLC · Orlando, FLBuilt 1964 · S/N 320C0025 N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291 N81RTN81rt LLC · Middlebury, CTBuilt 1973 · S/N 310Q0742 N81RYRedding Dermatology Medical Group Inc · Redding, CABuilt 1981 · S/N 340A1238 N81TBMalachi Leasing Co · Wilmington, DEBuilt 1978 · S/N TJ-147 N81TEMichaud Nathan M · Willows, CABuilt 1980 · S/N TH-1195 N81THStrand Christian P · Grand Rapids, MIBuilt 1978 · S/N 34-7870178 N81UCRegistration Pending · Orchard Park, NYRegistration pendingBuilt 1971 · S/N TH-142 N8201YTorqmation Inc · Houston, TXS/N 30-1320 N8203XLillieaire LLC · Olive Branch, MSS/N 34-8333029 N8203YMn98 LLC · Belview, MNBuilt 1966 · S/N 30-1322 N8204YBlue Steele LLC · Barnegat, NJBuilt 1966 · S/N 30-1324 N8206YBauer Electric Inc · Winona, MNBuilt 1966 · S/N 30-1331 N82073D K Engineering LLC · Sioux City, IABuilt 1982 · S/N 34-8233120 N8207YTwinkie Air LLC · Colville, WAS/N 30-1333 N8208YAirswiss Inc · Wilmington, DEBuilt 1966 · S/N 30-1334 N820FSAir Arctic Inc · Fairbanks, AKBuilt 1979 · S/N 317952185 N820JHHughes Leasing Co · Miami, FLBuilt 1981 · S/N 318152015

Back to AD 2004-25-16 R1