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.

N8287UPhillips Harry R · Oxford, PABuilt 1982 · S/N 34-8333027 N828ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496550 N828BFlight First LLC · Ixonia, WIBuilt 2010 · S/N 20800514 N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160 N828KMSjr Holdings LLC · Raleigh, NCBuilt 2001 · S/N TH-1999 N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098 N828LUMuldrow Erik · Newport, KYBuilt 1958 · S/N 23-1373 N828MJa Flight Services LLC · Sugar Grove, ILBuilt 1980 · S/N TC-2299 N828TTLoud LLC · Carthage, NCBuilt 1994 · S/N TH-1729 N8290ULets Fly LLC · Fortson, GABuilt 1993 · S/N TH-1688 N8294YNenno Richard W II · Bothell, WABuilt 1967 · S/N 30-1432 N8296YBl Aviation Services LLC · Camden, DEBuilt 1967 · S/N 30-1435 N8298YEstes Bernard R · Bumpass, VABuilt 1967 · S/N 30-1437 N829RBGlover William Scott · Mount Pleasant, TXBuilt 1980 · S/N TC-2305 N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064 N82BLSkylens LLC · Hammond, LAS/N 27-7754049 N82DAAircraft Holding Solutions LLC Trustee · Newark, DES/N 414A0476 N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463 N82GLJusticia Holdings LLC · Roanoke, VAS/N 414A0275 N82LBLakeland Aircraft Maintenance LLC · Lakeland, FLBuilt 1978 · S/N TH-910 N82RFRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 1985 · S/N 20800124 N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049 N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273 N82UCMajesty Air Inc · Wilmington, DEBuilt 1972 · S/N TH-276 N82XLFast Fly Inc · Dallas, TXBuilt 1981 · S/N 31T-8166034 N83003Bravo One LLC · Lewes, DEBuilt 1980 · S/N 44-8107018 N8302YArnold Roger R · Jonesville, LAS/N 30-1441 N8303PKh And G LLC · Spring, TXBuilt 1980 · S/N 44-8107031 N8303UInternational Air Service Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 348170048 N8303XDream Big Aero Corp · Wilmington, DEBuilt 1980 · S/N 34-8170049 N8304YLusk Thomas L · Centennial, COS/N 30-1443 N8306LStar Oil & Gas Co · Hobbs, NMBuilt 1980 · S/N 34-8170051 N8306NGularte Gavin · Berkeley, CAS/N 34-8170052 N8309YHolman Michael J · Anchorage, AKBuilt 1967 · S/N 30-1448 N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738 N830CCCreson John L Jr · Augusta, GABuilt 1970 · S/N TH-31 N830CM111 Aviation LLC · Lewes, DES/N 34-7350275 N830MUMarshall University · Huntington, WVBuilt 2021 · S/N 4496532 N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186 N830YDPrestige Aviation Group LLC · Orlando, FLBuilt 1976 · S/N 34-7770068 N8311YAj Air LLC · Cape Girardeau, MOBuilt 1967 · S/N 30-1450 N8313NSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1968 · S/N TC-1070 N8313YUnusual Attitudes LLC · Bates City, MOBuilt 1967 · S/N 30-1452 N8315ABrightwell Albert Jr · Seneca, SCBuilt 1980 · S/N 34-8170072 N8315YGolden Compass Aviation LLC · Wilmington, DEBuilt 1967 · S/N 30-1455 N8316YSchubnell Ryan A · Avondale Estates, GAS/N 30-1456 N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340 N831CPConstant Pleasure LLC · Paso Robles, CAS/N 310Q0813 N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293 N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279

Back to AD 2004-25-16 R1