AD 75-06-01
Registered aircraft · 2,832
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:75-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01')
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:75-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-06-01') 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.
N144KSAas LLC · Ovid, MIN1455TKenmore Air Harbor LLC · Kenmore, WAN145SLCash Depot Ltd · Green Bay, WIN146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXN146SLDodson International Parts Inc · Rantoul, KSN146WMWatermakers Air Inc · Fort Lauderdale, FLN148SAZuni LLC · Kirkland, WAN148SKBering Air Inc · Nome, AKN149CCCianbro Corp · Baltimore, MDN149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PAN149SFAlpine Aviation Inc · Provo, UTN14GVScott T LLC · Portland, ORN14RPAs350 LLC · Missoula, MTN1500EVaughans Aircraft Leasing LLC · Claremore, OKN1502BAeroag LLC · Portland, INN1502UCentral Ag Air LLC · Marion, KSN15054Air-Ag Inc · Tarboro, NCN15074Wells Flying Services LLC · Holdrege, NEN1507KDakota Air Spray LLC · Huron, SDN150ACJohnson Airspray Inc · Argyle, MNN150GWRocinante Air LLC · Cincinnati, OHN150KReilly John P · Friendsville, PAN15102Moes Crop Dusting Service Inc · Marysville, CAN1515GKidd Clifford L · Monahans, TXN15189Tri Rotor Spray & Chemical · Ulysses, KSN1518ZMoss Jimmy David DBA · Tillar, ARN1519ZFlatland Aviation LLC · Indianola, MSN151BCBrc Az Aviation LLC · Scottsdale, AZN151CAAcc Integrated Services Inc · Milwaukee, WIN151CLAircraft Structures International Corp · Enid, OKN1520QBrekhus Julius P · Kenmare, NDN15210O'Hare R Mike · Clovis, NMN1529ERoth Aerial Spraying LLC · Milford, NEN1529HMiller Aviation Inc · Norton, KSN1529USnider Scott E DBA · Turner, MTN152ALN152al LLC · Tulsa, OKN1531GWoodley Aerial Leasing LLC · Walnut, ILN1531SWakefield Aircraft LLC · Cooperstown, NDN1533SMj Aviation Inc · Walnut Ridge, ARN1539XRba LLC · Kimberly, IDN153GLAlpine Aviation Inc · Provo, UTN153KDMec International Trading LLC · Mission, TXN153PBCarojake LLC · Spartanburg, SCN153SLSouthwest Aviation Specialties LLC · Tulsa, OKN1540SArthur Aviation LLC · Arthur, NDN1544RRas Aviation LLC · Elyria, OHN1544VGuardian Flight LLC · Lewisville, TXN1547UR & D Leasing Inc · Lemoore, CAN154CAFedair Inc · Indianapolis, INN154CLAircraft Structures International Corp · Enid, OK
Back to AD 75-06-01