AD 75-08-03
Registered aircraft · 10,858
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-08-03')
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-08-03')
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-08-03') 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-08-03') 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.
N1479XDunn Michael J · Nashua, NHN1481XBadgerland Aero Club Inc · Fitchburg, WIN1484TPolasik Julia Suzanne · Victor, IDN1484XAlpha-One Air Service LLC · Concord, NCN1485XBond Bryce W · Chandler, AZN1486TSpivey Darwyn D · Guntersville, ALN1486XMidwest Investment Corp · Griffith, INN1487TFalcon Flying Club LLC · Fayetteville, GAN1491TGreat Lakes Air Ventures LLC · Mason, MIN1492TLargo Logistics LLC · Port Orange, FLN1498TMurwin Keith T · Douglasville, GAN1499HMeloney Leeyoung Chase · Peachtree City, GAN149DCDale Gared W · Hugo, OKN149JLKenyon Terry J · Henderson, ARN14DP5b Aviation LLC · Duncan, OKN14LNSchultz Tim J · Mount Juliet, TNN14NRPiper Capital Investments LLC · Denton, TXN15002Registered aircraftN15003Flying Untethered LLC · Saranac Lake, NYN15005Oliver Everett G · No Mankato, MNN15006Corio Salvatore J Jr · Warwick, RIN15007Marshall County Flying Club Inc · Lacon, ILN15010Van Buskirk James R · Tuttle, OKN15013Krantz Gwendolyn A · Advance, NCN1501XBowser William K · Ball Ground, GAN15021Brandywine Flight School · West Chester, PAN15022Registration Pending · Riverside, CARegistration pendingN15027Mallue Jeff · Springboro, OHN15032Ross Adam D · Bixby, OKN15033Fca Flight Training LLC · Washington C H, OHN15034Pathfinder Aviation Services LLC · St Johns, FLN15037Ace Aircraft Leasing Inc · Nazareth, PAN1503XGasoline Valley LLC · Clyde, MIN15044Summit Flight Academy LLC · Peculiar, MON15046Neboschick Ashley B · North Charleston, SCN1504JRuminski Pamela S · Salesville, OHN1504TChavez David L · Cedar Park, TXN1504XVerge Aeronautics LLC · Charlotte, NCN15050Houston William W · Baltimore, MDN15051Phoenix Proaviation LLC · Jacksonville, FLN15057Bad Dog Aviation · Meridianville, ALN1505XFarrell Donald A · Owasso, OKN15066Cherokee Aviation Group LLC · Alpharetta, GAN1506HRegistration Pending · Cape Canaveral, FLRegistration pendingN1506TWaldrep Zoey V · Tampa, FLN15079Rea Robert III · Bumpass, VAN1507TAero Care Inc · Orange, MAN1508JLiwag Reynaldo T Jr · Niagara Falls, NYN1508TWalker Jereme · Durham, NCN150PKInternational Air Services Inc Trustee · Carson City, NV
Back to AD 75-08-03