AD 96-03-13
Registered aircraft · 1,042
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:96-03-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:96-03-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:96-03-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:96-03-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.
N69084Konen Rock Products Inc · Milton Freewater, ORN690SCN690sc One LLC · Dover, DEN694KMCarling Technologies Inc · Plainville, CTN697PStaker & Parson Co · Ogden, UTN699ALBallard Aviation Inc · Newton, KSN699BWBeech Transport LLC · Tarboro, NCN699CZN699cz LLC · Milwaukee, WIN6VJN6vj LLC · Coleman, FLN700BAAviation Inventory Resources Inc · Alvarado, TXN700LXLimpia Logistics LLC · Midland, TXN700NAAtlanta Air Charter Inc · Kennesaw, GAN700ZAti Aviation LLC · Johnstown, PAN702MAZion Asset Management LLC · Saint Clair Shores, MIN703LTAt Aero LLC · Wilmington, DEN703MDavis Aviation Inc DBA · Brandon, MSN70CULou Dell Aviation LLC · Simpsonville, SCN70JJWilmington Trust Co Trustee · Wilmington, DEN70MNState Of Minnesota · Saint Paul, MNN70NPBemidji Aviation Services Inc · Bemidji, MNN710JBSunset Leasing Inc · Sarasota, FLN710NCNorth Country Aviation Inc · Gaylord, MIN711LFlorida Aero Services S D · Brandon, FLN711REMontana Aircraft Trust Inc Trustee · Bozeman, MTN711VVMaynard Aviation LLC · Westfield, MAN712RHBtr Air Charter-Ka LLC · Baton Rouge, LAN713RHFalcon Air LLC · Olive Branch, MSN715RDHalls Aviation LLC · Charleston, SCN716APButler Aviation Inc · Houma, LAN716AVMas Trailers LLC · Dalhart, TXN716TAB P Air LLC · Delhi, LAFirst renewal noticeN717DCAircraft Unlimited Inc · Pierre, SDN717VAAtlanta Air Charter Inc · Kennesaw, GAN719BHWilliams Farms LLC · Panhandle, TXN71VTWestern Wings Corp · Roseburg, ORN7206EEt Aviation LLC · Alcoa, TNN720AMKing Eagle II LLC · Grand Blanc, MIN720COscar Charlie LLC · California, MDN721EAAcellerated Interventional Orthopedics Pllc · Lawton, OKN721RDKing Edward Inc · Cullman, ALN721RFEdgington Transport LLC · Livermore, CAN722BRB&L Aviation LLC · North Myrtle Beach, SCN722TRJamair LLC · Poland, OHN724AAAlbright Insurance Holdings Inc · Burlington, NCN7250TEpic Aviation Inc · New Smyrna Beach, FLN725RABar Environmental Supply Inc · Brentwood, TNN727BCue Capital LLC · Edmond, OKN727BWAcc4m LLC · Augusta, GAN72HTSan LLC · Knoxville, TNN730HMIsr Aviation LLC · Wilmington, DEN744PCCorzon Aircraft Sales LLC · Highland Park, IL
Back to AD 96-03-13