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.
N11KAlbers Edward C · Burlington Flats, NYN11NTSabb Anthony · Wetumpka, ALN1203TProfessional Locators & Acquisition Specialists Ll · Severance, CON1204THigh Sky LLC · Ellensburg, WAN1205TAmerican Aircraft Management LLC · Irving, TXN1206TCps 1 LLC · Pelham, ALN120CDJackson Farms Callahan Division LLC · Callahan, FLN120PWBrookhaven Aviation LLC · Brookhaven, MSN1213TDyer Gary T · Reno, NVN1214TPost 8 Flight Opps Inc · Topeka, KSN1216TOlsen Christopher D · Bothell, WAN1217TSauer Roger A · Glenburn, NDN121DBTexins Flying Club · Mckinney, TXN121ESWell Bilt Industries USA LLC · Ocala, FLN121MDBaggarly Michael · Newnan, GAN1222TPraniewicz Charles P · New Kensington, PAN1226TLinde Glenn F Jr · Juneau, WIN1227TStieper David Paul · Forest Lake, MNN122HSMarbury Sherri E · Jackson, TNN1232TAlexander Charles W · Slidell, LAN12354Spencer Christopher · Voorheesville, NYN1235SBarney Erick L · Jacksonville, ORN1236TOtero Edgardo A · Tucson, AZN1237HGivens Timothy A · Collierville, TNN123GEFlying Four Inc · Saint Petersburg, FLN123JCDippolito Mario M · Sherwood, ARN123SWBelschner Custom Meats · Amherst, NEN1241TGale Richmond T · Tewksbury, MAN1242TDoblmaier Thomas J · North Wales, PAN124JCDestination Aviation LLC · Destin, FLN1250TStanley Natasha S · Lorton, VAN1251TMcvey Cindy M · Colts Neck, NJN1253TDellemonoche Dennis R · Tabernacle, NJN1254TStewart Doug A · Indianola, NEN1260TRed Rock Flying School LLC · Mesa, AZN1261TObrien Timothy D · Alplaus, NYN1264THolloway Andrew F · Woodville, TXN1268TFortney Thomas Kent · Humble, TXN1270TTubman Wilbur C · Grand Rapids, MIN1272TMyers Brent A · Palm Bay, FLN1273TZulu Aviation LLC · Newcastle, OKN12757Altitude Aviation Group LLC · Christmas, FLN1276TShillieto Mark C · Wilmington, OHN1278TSmith Sullivan · Cookeville, TNN127MDCosbie Lee R · Tuscumbia, ALN1280TCertified Equipment Inspections LLC · Washington, PAN1284NAbnc Air LLC · Wellington, FLN1284WBethel Don G · Bossier City, LAN1286THeffelfinger Paul D · Seven Valleys, PAN128DPGherebi Belaid A · San Diego, CA
Back to AD 75-08-03