AD 95-26-13
Registered aircraft · 21,464
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
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-13')
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-13')
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-13') 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-13') 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.
N1477XRed Rock Flying School LLC · Mesa, AZN1478XMello Edward R Jr · Land O Lakes, FLN1479TWnc Aviation LLC · Arden, NCN1479XDunn Michael J · Nashua, NHN147GArcher Aero LLC · Wilmington, DEN147LHSchool Board Of Brevard County Florida · Melbourne, FLN147PJVargas Luis A · Isabela, PRN1481XBadgerland Aero Club Inc · Fitchburg, WIN1484TPolasik Julia Suzanne · Victor, IDN1484XAlpha-One Air Service LLC · Concord, NCN1485XBond Bryce W · Chandler, AZN1486HLynn John · Coffee Creek, MTN1486TSpivey Darwyn D · Guntersville, ALN1486XMidwest Investment Corp · Griffith, INN1487TFalcon Flying Club LLC · Fayetteville, GAN1488HDeplazes Anthony · Rugby, NDN1489TLion Aviation LLC · Kansas City, MON148AParagon Flight Training Co · Fort Myers, FLN148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLN148KMRstl LLC · Minster, OHN148LHFarmingdale State University · Farmingdale, NYN148RFPaklook Air Inc · Bethel, AKFirst renewal noticeN1490HKoepke Jeffrey J · Waterford, WIN1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN1490XTwin Peaks Holdings · Midvale, UTN1491CYancey Wesley · Leonardtown, MDN1491TGreat Lakes Air Ventures LLC · Mason, MIN1492TLargo Logistics LLC · Port Orange, FLN1496HCapital Acquisitions LLC · Atchison, KSN1497XTundra Toyo And Heating LLC · Nome, AKN1498TMurwin Keith T · Douglasville, GAN1499HMeloney Leeyoung Chase · Peachtree City, GAN149DCDale Gared W · Hugo, OKN149DTNew Mexico Flying Eagle Inc DBA · Tucson, AZN149JLKenyon Terry J · Henderson, ARN149LHFarmingdale State University · Farmingdale, NYN14BEBelmont Circle LLC · Virginia Beach, VAN14DJJ&N Management Inc · Wilmington, DEN14DP5b Aviation LLC · Duncan, OKN14DWBurnett Timothy S · Birmingham, ALN14LNSchultz Tim J · Mount Juliet, TNN14NRPiper Capital Investments LLC · Denton, TXN14PZDivinia Dustin · Bonham, TXN14RWJohnston Jeffrey T · Ramsey, MNN14YBKate Air LLC · Southlake, TXN15002Registered aircraftN15003Flying Untethered LLC · Saranac Lake, NYN15005Oliver Everett G · No Mankato, MNN15006Corio Salvatore J Jr · Warwick, RIN15007Marshall County Flying Club Inc · Lacon, IL
Back to AD 95-26-13