Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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.

N2023ASouthern Cast Products Inc · Meridian, MSBuilt 1978 · S/N TC-2168 N2023KJuliet Foxtrot LLC · Scott City, KSBuilt 1978 · S/N TC-2169 N2023WSpecialty Extrusion Marketing Co Inc · Dover, DEBuilt 1965 · S/N TC-971 N2023ZSchulert Peter · Lebanon, TNS/N TC-2171 N2024CD M S Leasing Co LLC · Las Vegas, NVBuilt 1959 · S/N TD-198 N2026CSkys Aircraft Corp · Newnan, GABuilt 1959 · S/N TD-193 N2028WN2028w LLC · Oakdale, CABuilt 1966 · S/N TE-87 N2029CAnderson Rebecca L · Fort Myers, FLS/N TD-197 N202ACBank Of Utah Trustee · Salt Lake City, UTS/N 1308 N202DKAuto Key Masters And Locksmith LLC · Watts, OKBuilt 1978 · S/N TC2152 N202FRUmb Bank N A Trustee · Salt Lake City, UTBuilt 2008 · S/N 3431 N202MDHay Pile Aviation LLC · Gilbert, AZBuilt 1966 · S/N TE-148 N202NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2013 · S/N 5440 N202SBHayes Floyd R · Hideaway, TXS/N WA-22 N202UXAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-202 N2033CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-203 N2034A36 Echo Aviation LLC · Prospect, KYBuilt 1978 · S/N TC-2179 N2035WTitanium Aircraft LLC · Wilmington, DEBuilt 1965 · S/N TE-19 N2038WYanagida Kazuaki · Norco, CABuilt 1973 · S/N LD-459 N203NVSunrise Asset Management LLC · Las Vegas, NVBuilt 2012 · S/N 5384 N2042CDms Leasing Co LLC · Las Vegas, NVS/N TD-219 N2042ESmith James E Trustee · Kalispell, MTS/N TC-2188 N2043GBreaking Wind LLC · Alabaster, ALBuilt 1978 · S/N TC-2189 N2044PSnoe Gary A · Somerville, TXS/N TC-2178 N2049CPray Matthew W · Augusta, KSBuilt 1959 · S/N TD-234 N2049KUas Transervices Inc · Boca Raton, FLBuilt 1991 · S/N UC-164 N204KMInternational Air Services Inc Trustee · Carson City, NVS/N 340-0070 N204NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 5166 N204UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 28713 N2050CDow Jeffrey W · Port Hadlock, WAFirst renewal noticeBuilt 1959 · S/N TD-229 N2051BPlanepower LLC · Meridian, MSBuilt 1978 · S/N TC-2196 N2054CParker Jerry B · Arcola, TXBuilt 1959 · S/N TD-245 N2055PPechacek Justin D · Snyder, TXBuilt 1979 · S/N TC-2235 N2058AFlying J Aviation LLC · Lynden, WABuilt 1979 · S/N TC-2201 N205NVUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 5724 N2061UGulf Coast Camp LLC · Lafayette, LABuilt 1979 · S/N TC-2202 N2062CBc Realty Group LLC · Lake Dallas, TXBuilt 1959 · S/N TD-262 N20649Echo Lima LLC · Newport, ARBuilt 1979 · S/N TC-2206 N2064COchoa Stanley · Woodland, CABuilt 1979 · S/N TC-2212 N2064KDiamond O Ranch LLC · Fredericksburg, TXBuilt 1979 · S/N TC-2204 N2065LAirspeed Jet Services LLC · Kirkland, WABuilt 1959 · S/N TD-209 N206FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4272 N206NVAllegiant Air LLC · Las Vegas, NVBuilt 2012 · S/N 5289 N206SBtpr Solutions LLC · Wilmington, DEBuilt 1965 · S/N TC-873 N206UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 30212 N2070WLeisure Air II LLC · Columbus, GABuilt 1965 · S/N TC-974 N2074LTb7 LLC · Kalispell, MTBuilt 1976 · S/N TC-1975 N2078WLawrence Dayle DBA · Scotia, CABuilt 1966 · S/N TE-83 N207AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30438 N207FRUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 4307

Back to AD 95-26-15 R1