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.

N777KFJ And P Air LLC · Lockport, NYBuilt 1963 · S/N TC-520 N777KGLonnevik Dennis F · Bigfork, MTBuilt 1966 · S/N 30-1159 N777KPKelly'S Flying Service LLC · Warrensburg, MOBuilt 1963 · S/N 30-110 N777LLHelfrich Vincent · Lawrence, MABuilt 1971 · S/N TC-1410 N777MEDe La Garza De La Fuente Jose A · Montgomery, TXBuilt 1980 · S/N 31-8012049 N777NHS And S Airlink · Troy, MIBuilt 1978 · S/N 340A-0415 N777PMAccurate Aero LLC · Minden, NVBuilt 1964 · S/N 310I0078 N777QAMabry Kelly · Russellville, ARBuilt 1970 · S/N TH-143 N777RABirdsong Michael L · St Simons Island, GABuilt 1981 · S/N TH-1273 N777RHLarson Peter T Trustee · Coraopolis, PABuilt 1965 · S/N 30-908 N777RPParis Air Conditioning Co · Paris, TXBuilt 1974 · S/N 414-0636 N777RQSchelde Brian L · Marble Falls, TXBuilt 1973 · S/N TH-298 N777SGClaw LLC · Lake Saint Louis, MOS/N TH805 N777TKProfessional Paving Services LLC · Macon, GABuilt 1979 · S/N TH-1018 N777TSEmery Edward F DBA · Bloomsburg, PAFirst renewal noticeS/N 421B0352 N777VFZammit Flight Resources LLC · Sheridan, WYBuilt 1977 · S/N 414-0946 N777VZFreeman Brooks · Richmond, VABuilt 1981 · S/N 31-8212012 N777WVIndependent Mortgage · Westlake, LABuilt 1996 · S/N TH-1784 N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193 N777ZTSee David M · Shady Shores, TXBuilt 1966 · S/N 320E0033 N7782QFanning Fred W · Fairlawn, OHBuilt 1971 · S/N 310Q0282 N7786YBell Frank · Tuxedo, NCBuilt 1965 · S/N 30-869 N7787YBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 30-870 N7790YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-146 N7791YMaki Stephen B · New Port Richey, FLBuilt 1965 · S/N 30-874 N7792QSchultz Todd · Bakersfield, CAS/N 310Q0402 N7793QJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1971 · S/N 310Q0403 N7793YRedinger Aaron · Hanlontown, IABuilt 1965 · S/N 30-876 N7794QRg Aviation Inc · Wilmington, DEBuilt 1971 · S/N 310Q0404 N7796NBas Part Sales LLC · Greeley, COBuilt 1968 · S/N TC-1192 N779DBAirjohn LLC · Cheyenne, WYBuilt 1985 · S/N TJ-489 N779MRRock N Robins Flying Service LLC · Palm City, FLBuilt 1976 · S/N 27-7654047 N779NMCallahan Mfg Inc · Royal City, WABuilt 1967 · S/N TC-1053 N77BRInternational Air Services Inc Trustee · Carson City, NVBuilt 1975 · S/N 340A-0053 N77CDN-J Aviation LLC · Forest, VABuilt 1975 · S/N 414-0646 N77CHTcb Management Inc · Chiefland, FLBuilt 1971 · S/N 39-136 N77DNGrant County Mosquito Dist #1 · Moses Lake, WABuilt 1969 · S/N 33701234 N77DSBalderas Alberto · Harlingen, TXS/N 317812061 N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478 N77FTCapeplane LLC · Cape May, NJBuilt 1997 · S/N 3449018 N77KKMensch Aviation LLC · Hastings, MIBuilt 1980 · S/N 278154002 N77KPInformation Softworks Inc · Ann Arbor, MIBuilt 1981 · S/N 34-8133067 N77KTRochna Stephen J · Fallon, NVBuilt 1958 · S/N 23-1306 N77LBEleuthera II LLC · Mesa, AZBuilt 1974 · S/N TH-536 N77LVAviacion Del Oeste Inc · Mayaguez, PRBuilt 1980 · S/N TJ-287 N77MBCosgrove D DBA · Crestview, FLBuilt 1964 · S/N 310I0068 N77NFNate Holyoke Builders Inc · Holden, MEBuilt 2004 · S/N 20800382 N77NLNew South Inc · Charleston, SCBuilt 1977 · S/N 31T-7720038 N77NWRizor Justin · Phoenix, AZS/N TK-141 N77QBDeauxboys LLC · Menomonee Falls, WIBuilt 1976 · S/N 340A0120

Back to AD 2004-25-16 R1