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.

N93WABranciforte Louis N · Watsonville, CABuilt 1977 · S/N 34-7770390 N9403QBlue Sky Baron LLC · Highlands Ranch, COBuilt 1970 · S/N TH-54 N940LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496485 N9411QWhite Tavis · Huntsville, ALBuilt 1970 · S/N TH-66 N9414ARitchie Race S · Odessa, TXS/N 414A0267 N9415CSouthwest Plane Holdings LLC · Kalispell, MTBuilt 1983 · S/N T30300176 N9420YPremier One Express LLC · Orlando, FLBuilt 1964 · S/N TC-582 N9421FJst Management LLC · Zephyrhills, FLS/N 20800049 N9429QBuck Hollow Investments LLC · Austin, TXBuilt 1972 · S/N TH-200 N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116 N942SWVascoe Jeffre M · Houston, TXBuilt 1981 · S/N 421C1025 N9430Cochise College · Douglas, AZBuilt 1968 · S/N TC-1194 N943PWRegistered aircraftAssigned, pending cancellationS/N TC-627 N9446QGalt Gulch LLC · Ann Arbor, MIBuilt 1972 · S/N TH-236 N944GMSix States Rentals Inc · Union, MOBuilt 1978 · S/N 31T-7904005 N9450CStadler Kristopher D · Makawao, HIS/N 34-7870188 N9454FPofolk Aviation Hawaii Inc · Honolulu, HIBuilt 1985 · S/N 20800028 N945BRegistered aircraftBuilt 1974 · S/N TC-1826 N945BGDavis James H · Corpus Christi, TXBuilt 1980 · S/N 421C-0870 N9466QLan Dale Co · Reno, NVBuilt 1972 · S/N TH-205 N9467QAg Aero Inc · Tallulah, LABuilt 1972 · S/N TH-206 N946TTTalley Tank Lines Inc · Madera, CABuilt 1992 · S/N TH-1673 N9476CZulu Echo Assets LLC · Port Washington, NYBuilt 1982 · S/N T30300179 N9478QWwpc Aviation LLC · Stanley, VABuilt 1972 · S/N TC1431 N947MRonneburger Brian · Northport, NYBuilt 1969 · S/N 30-1947 N9480KLegacy Pursuit LLC · Godfrey, ILBuilt 1976 · S/N 34-7670206 N9481FIsr Aviation LLC · Wilmington, DEBuilt 1985 · S/N 20800070 N9488CGalloway Christopher · Davis, CABuilt 1982 · S/N T30300180 N948FBDye James R · Munster, INBuilt 1998 · S/N 3449057 N948MTTrasko Mark S · Boulder, COBuilt 1975 · S/N 31P-7530028 N9494SLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1966 · S/N TC-985 N949FMackin Aviation LLC · Scottsdale, AZS/N 20800602 N949RDenome Vincent G · Tampa, FLBuilt 1962 · S/N 310G0148 N949WAP S S Air Inc · Middlesboro, KYBuilt 1976 · S/N 31-7612069 N94JMRegistration Pending · College Station, TXRegistration pendingS/N 31P-47 N94KMBurton Aviation LLC · Burlington, NCBuilt 1997 · S/N TH-1816 N94MTWindway Capital Corp · Sheboygan, WIBuilt 1986 · S/N 20800089 N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245 N94RWWithers Dana Ruth Executor · Mount Vernon, ILBuilt 1981 · S/N 414A0662 N94TJHuber Robert T · West Chester, PABuilt 2002 · S/N TH2029 N94YCBeauchene Mark J · Des Moines, IABuilt 1965 · S/N 30-899 N950CTJack Of Queens LLC · Afton, OKBuilt 1977 · S/N 31T-7720069 N950RFRandigo LLC · Wilmington, DEBuilt 1989 · S/N 20800150 N950SACrop Dusters LLC · Maurice, IABuilt 1981 · S/N 31T-8166028 N951AMRowan Edward L · Wellington, FLBuilt 1975 · S/N TC 1884 N951DSDerrick Schmidt Enterprises Inc · Vinita, OKBuilt 1978 · S/N TH-898 N951GPBlind Dog Aviation LLC · Jacksonville, FLS/N 34-8070052 N951LEChi Walter D · Aspen, COS/N 320F-0029 N951POncourse LLC · Miami, FLBuilt 2001 · S/N TH-2015 N9528CAldrich Air Transport LLC · Saint Augustine, FLBuilt 1978 · S/N 34-7870195

Back to AD 2004-25-16 R1