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.

N7707YLoveless John R Trustee · Bynum, TXBuilt 1965 · S/N 30-712 N7709JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496100 N7709YBauer Aviation LLC · Reese, MIBuilt 1965 · S/N 30-797 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N770CDCunningham Campers & Rvs · Clarksville, INBuilt 1976 · S/N 33701774 N770CSFlying Cpa LLC · Colorado Springs, COBuilt 1975 · S/N 421B0877 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N770LAGulf Airbatics Ltd · Jennings, LABuilt 1974 · S/N TH-517 N770MGPlan Bee LLC · Washington, DCS/N 31T7520029 N7710KAtd Pilot Training LLC · Kansas City, MOBuilt 2001 · S/N 4496101 N7710QRegistered aircraftBuilt 1970 · S/N 310Q0210 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7711QHot Start Aviation LLC · Chapin, SCBuilt 1968 · S/N 310N-0073 N7712RJerry T And Beverly H Davis Family Lp · Monticello, ARFirst renewal noticeBuilt 1968 · S/N TC-1167 N7713YDarragh Jeff · Fort Myers, FLBuilt 1965 · S/N 30-802 N7715RJames S Adcock III Pa · Fuquay-Varina, NCBuilt 1968 · S/N TC-1165 N7717VCarver Aero LLC · Muscatine, IABuilt 2002 · S/N 4496120 N7718AScud Air 18a LLC · Morgan, UTBuilt 1975 · S/N 27-7554040 N7719QTurel Stanley · Bend, ORBuilt 1973 · S/N 3400194 N7719XBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 4496130 N771BCDavid Slack · Hamersville, OHBuilt 1972 · S/N 310Q0601 N771MPFl072 Aviation LLC · Brentwood, TNBuilt 1974 · S/N 340-0368 N771PMaxq Composites LLC · Oxford, MEBuilt 1969 · S/N 337-1165 N771WNJordan Hugh Lowe Jr · Centre, ALBuilt 1965 · S/N TC-883 N7720YEastern Kentucky University · Richmond, KYBuilt 2002 · S/N 4496132 N7723QBackyard Aero LLC · Rockville, INBuilt 1970 · S/N 310Q0223 N7724CBiedenharn John D · Sunset Beach, CABuilt 1975 · S/N 34-7670102 N7724QBned LLC · Tupelo, MSBuilt 1970 · S/N 310Q0224 N7727QDivinia Darin D · Graham, TXBuilt 1970 · S/N 310Q0227 N7728YArr Enterprises Inc · Yorkville, ILBuilt 1965 · S/N 30-817 N7729QMowinski Frank R Jr · Ray, MIBuilt 1970 · S/N 310Q0229 N7729YFogle Neil · Conroe, TXBuilt 1965 · S/N 30-818 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N7732YPurcell David S · Chandler, AZBuilt 1965 · S/N 30-821 N7734YRussell R Bruce · Clayton, GABuilt 1965 · S/N 30-824 N7738RKing Robert B · Sheridan, WYBuilt 1968 · S/N TC-1175 N7738YAristizabal Leonardo · Van Nuys, CABuilt 1965 · S/N 30-828 N7739QHarding William R Jr · Quinlan, TXBuilt 1970 · S/N 310Q0239 N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N773TMSouthern Mooney Inc · Wilmington, DEBuilt 2012 · S/N 3449463 N7742GEmmons Michael R · Temple, TXBuilt 1984 · S/N 34-8433047 N7742QStarr Brian Layton · Joliet, MTBuilt 1970 · S/N 310Q0242 N7743QCrampton Scott C · La Jolla, CABuilt 1971 · S/N 310Q0243 N7743YSchroeder David C · Norfolk, NEBuilt 1965 · S/N 30-833 N7744QRegistered aircraftBuilt 1971 · S/N 310Q0244 N7744YCossette Aircraft LLC · Laporte, MNBuilt 1965 · S/N 30-835 N7746YSnow Robert I · New Caney, TXBuilt 1965 · S/N 30-837 N7747YBohannon Philip Wayne · Houston, TXBuilt 1965 · S/N 30-838 N774CERegistration Pending · Saint Paul, MNRegistration pendingS/N 31-7712047 N774DCBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 340A0206

Back to AD 2004-25-16 R1