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.
N15100Brothers Aviation Va LLC · Manassas, VAN15101Blackwater Air LLC · Pace, FLN15104Mil2atp Inc · Pikeville, NCN15105Sass Phillip A · Leavenworth, KSN15106Chew Terrence G · Allyn, WAN15107Skahen Sean M · Saint Joseph, MNN1510XSedlacek John · Pittstown, NJN1511Plane Fun LLC · Warrensburg, MON15115Price Michael D · Shell Knob, MON15118Illinois Valley Flying Club Inc · Peru, ILN15121Airborne Aviation LLC · Anchorage, AKFirst renewal noticeN15122Dixson Joel T · Corpus Christi, TXN15123Blackwood Aviation Services Inc · Orlando, FLN15125Mallozzi Michael A · Albuquerque, NMN1512JHorning Timothy J · Saegertown, PAN15132Lewis University · Romeoville, ILN1513XTurner Gary H · Big Stone Gap, VAN15140Anthony J Cariotte Jr · Holbrook, NYN15141Murphy Jeffrey S · Mechanicsburg, PAN15142Dj Aviation LLC · Rio Vista, TXN15148Brown Jerry Keith · Calera, ALN1514JBooher Greg F · Livingston, TNN1514TTucker David J · Welch, OKN1514XRabidou Gary R Jr · Lancaster, MAN15151Smith Jared · Allendale, ILFirst renewal noticeN15159Piper One Five Niner Inc · Greenville, WIN1515JMendenhall William R II · Beebe, ARN1515TSussman Steven T · Goshen, NYN15160Western Aire Flying Club Ltd · Sparta, WIN15169Stephens Brennan · Irving, TXN1516JH&H Holding LLC · Tucson, AZN15176St Germain Joseph Ronald · Glenview, ILN15179Henson Ricky T · Covington, TNN1517JPardiac Kenneth R · Howell, MIN1517XDippolito Thaddeus M · Sherwood, ARN15190Coastal Air · Groton, CTN15191Lumpp John R · Old Brookville, NYN1519XAycd LLC · Allentown, PAN151DJValley City Flying Club Llp · Valley City, NDN151DSCastro Salvador A · Houston, TXN151MMBas Part Sales LLC · Greeley, CON151SFRomeo-3 Aviation LLC · Marietta, GAN15203Hummel David R · Cedar Falls, IAN15204Arthur Jeffery L · Lima, OHN15207Tiburon Aviation LLC · Tampa, FLN1520TAaa Aero LLC · Glenwood, MNN15223Dobson Anthony Eric · Alexandria, VAN15224Ludlow Reba J · Ponte Vedra Beach, FLN15226Blackwell Stephen E · Burlington, NCN15228Registered aircraft
Back to AD 75-08-03