AD 74-18-13
Registered aircraft · 1,642
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:74-18-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:74-18-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:74-18-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:74-18-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.
N33864Hirsch Bernard David · Carmel, INN3386WTranswestern Air Service Inc · Golden, CON3388WTexas Wings LLC · San Antonio, TXN3389WUniversity Of Alaska Anchorage · Anchorage, AKN3390WClear Blue Skies LLC · Saint Paul Park, MNN3391WNeckerauer John R · Acme, PAN3392WMartinez Paul · Sonora, TXN3393DFiscus Ronald E III · Anchorage, AKN3395WGabrick Steven J · Hickory Valley, TNN3396WDaubert Donald W · Chandler, AZN3397WLarson Robb J · Danbury, WIN33JDRiggs Alan Vance · Artesia, NMN3400WTop Flight Aircraft Holdings LLC · Dover, DEN3402WCw Baker Investments LLC · Baton Rouge, LAN3403WSchendel Daryl R · Barstow, CAN3406WQwikflights LLC · Herriman, UTN3407WYounkin Anthony · Ruffs Dale, PAN3410MArborio Peter J · Wethersfield, CTN3411WAmerican Airpower Museum · Farmingdale, NYN3412WN3412w LLC · Lithia, FLN3414WIrby Almous · Enterprise, ALN3415WSutton Aircraft Salvage LLC · Palmer, AKN341SW13:4 Aviation LLC · Brookfield, WIN3420WBuffington Brian C · Gillsville, GAN3424WHobaugh Auto Parts Inc · Karns City, PAN3427WHurricane Air LLC · Fremont, OHN3430WHerring Taylor R · Laredo, TXN3432WNunak Air Taxi LLC · Kenai, AKN3436WIsland Aviation Management LLC · Plainview, NYN3438WBlue Wanderers · Fort Wayne, INN3440WGood Earth Farms Inc · Hastings, NEN3441QBluegrass Skyriders LLC · Vine Grove, KYN3441WN3441w LLC · Shickley, NEN3442WRad Eye LLC · Wilmington, DEN3445WTrembly Alexander · Horner, WVN3447WStimart Rene D Trustee · Harshaw, WIN3450WRst Aviation LLC · Vero Beach, FLN3453WBrown Craig · Vernal, UTN3454WRoos Paul A · Lake City, FLN3455WClark James A · Walnut Creek, CAN3457WBas Part Sales LLC · Greeley, CON3458WBerquist Glenn A · Columbus, MSN3459WPannell Lucas J · Midland City, ALN3460WCarruth John T · Danvers, MNN3467WRobinhood Aero LLC · Southaven, MSN3471WKoranda Amy B · Salem, SCN3476WFletcher Gayle J · Conroe, TXN3477WStevens Brad · Chandler, AZN3478WDouble D Air LLC · Killeen, TXN3481WSandpiper Air LLC · Charles Town, WV
Back to AD 74-18-13