Registered aircraft · 10,536

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.

N1116PSale Reported · Scottsville, VASale reportedBuilt 1955 · S/N 23-126 N1116TImg Management Services Corp · Wapwallopen, PABuilt 1968 · S/N TC-1127 N1118TFriend Air Care Inc · Washington, PABuilt 1964 · S/N TC-813 N111ALBc Builders Inc · Temecula, CAS/N TH484 N111ATSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 337-1125 N111AWC&A Aviation LLC · Mcintyre, GABuilt 1977 · S/N TH-841 N111BXDonadio Robert F · Amherst, NHBuilt 1972 · S/N 414-0368 N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105 N111DLCresence LLC · Port Saint Lucie, FLBuilt 1976 · S/N 27-7654167 N111FGHahn Derrick J · Combine, TXS/N TC2026 N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050 N111GTMorgan Gerald W · Hillsboro, TXS/N 340-0188 N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 N111KFColorado Jet Solutions Inc · Conifer, COBuilt 1964 · S/N TC-633 N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092 N111PDN111pd LLC · Wilmington, NCBuilt 1978 · S/N TC-2176 N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001 N111PJG&L Aviation Services LLC · Las Vegas, NVBuilt 1981 · S/N 340A1234 N111PLColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1969 · S/N 301929 N111PQTriple Nickel Inc · Muleshoe, TXBuilt 1972 · S/N TC1427 N111RBClear Skies LLC · Allentown, PABuilt 1978 · S/N 340A0545 N111RXThompson William · Tampa, FLS/N 347770134 N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333 N111TFPacific Aviation Aircraft Management Inc · Ontario, ORBuilt 1974 · S/N 421B0660 N111TLNdk Global Holdings Corp · Dover, DEBuilt 1974 · S/N 421B0645 N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190 N111VMSkyline Aeronautical Services LLC · Dorado, PRBuilt 1977 · S/N TC-2081 N111WDSmith Toby D · Cresson, TXBuilt 1978 · S/N TC-2126 N111XBoone Aviation Ltd · Denver, COBuilt 1965 · S/N 310J0108 N111XLNova Aircraft Inc · Clearwater, FLS/N P-197 N111XXBay Area Flying Service LLC · Burlingame, CABuilt 1983 · S/N TH-1389 N1121QTwomey Kieran S · Coronado, CABuilt 1963 · S/N 310H0121 N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133 N1129QTippecanoe Valley Aero Inc · Delphi, INBuilt 1963 · S/N 310H0129 N1129SGarmin International Inc · Olathe, KSBuilt 1997 · S/N TH-1812 N1129WSilver Wing Aviation LLC · Wilmington, DEBuilt 1997 · S/N TH-1809 N112ACJones Michael · Freeport, TXBuilt 1964 · S/N TC-681 N112ALPassport Auto & Aviation Inc · Richmond, VABuilt 1979 · S/N 421C0697 N112HBenschoter Cameron · Bonifay, FLS/N TC-722 N112HPBertagnole Karl R · Wright, WYBuilt 1964 · S/N 310I0104 N112MJTm Aero LLC · Riverview, FLS/N 421C0907 N112PCTaylor Bradley S · Abilene, TXBuilt 1976 · S/N TH-720 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1133QHaggard Haley G · Springer, OKBuilt 1963 · S/N 310H0133 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N113ABSafford Aviation Service Inc · Coolidge, AZBuilt 1973 · S/N TC-1622 N113DFRegistered aircraftBuilt 1998 · S/N 3449062 N113GLBushwacker Aviation LLC · Benton, ARBuilt 1978 · S/N 414A0072 N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226

Back to AD 2004-25-16 R1