AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N2744YDe Vuyst Richard C · Pampa, TXN27457Felix Margarita G · Nogales, AZN2745FAlexander Production Co · San Antonio, TXN2745GKj3 Air LLC · Mitchell, SDN2745JRegistered aircraftN2745QAero Docs LLC · Butte, MTN2745SGobble Larry L · Williamson, GAN2745UMidfield Aviation LLC · Caldwell, IDN2746GMchugh Rick M · Enumclaw, WAN2746JGelatt Joseph · Wasilla, AKN2746LBeavers Timothy · Charlotte, NCN2746SBryant Stan M · Derby, KSN2747JRamstad Phillip J Trustee · Anchorage, AKN2747LGuistwhite Brian K · Etters, PAN2747QMosier Michael J · Kalamazoo, MIN2747VDavis Brady L · Monument, CON2747XTaylor Joseph Baker · Anchorage, AKN2748LCarter Reagan Tye · Beaumont, TXN2748QDavie Walter C · Los Angeles, CAN2749EB2fh Ltd · Allentown, NJN2749FSummersell Chadwick G · Chattanooga, TNN2749JFithian Cody D · Wasilla, AKN2749KAero Applicators Inc · Sterling, CON2749LBeeker Martin J Jr · Plymouth, MIN274DAArnold Randall L · Corpus Christi, TXN274DBAlvray LLC · Enumclaw, WAN274DCMaggie 288 LLC · Quincy, WAN274GTSkogen Joseph S · Coeur D Alene, IDN274MBAdams Aviation Services Inc Trustee · Wilmington, DEN274MCLone Eagle Aeronautica LLC · Duncan, OKN274MDDickenson Bruce E Trustee · Santa Paula, CAN274MRAero Systems Inc · Broomfield, CON274PMPlanemasters Ltd · West Chicago, ILFirst renewal noticeN274TLussier Ian · Owls Head, MEN274VFSkylane Victor Foxtrot LLC · Annapolis, MDN2750SMcmichael Olen G · Antwerp, OHN2750UMartin Maximilian · Sonora, TXN2751FAzuris & Co · Albuquerque, NMN2751QValu Prop LLC · Fargo, NDN2752FSchoppaul David · Anthem, AZFirst renewal noticeN2752GZambarano Matthew C · South Hero, VTN2752QAnspaugh Bruce E Trustee · La Crescenta, CAN2752SWhite Orion H · Moses Lake, WAN2752VAnninos Peter J · Seal Beach, CAN27532Shadow Aviation Inc · Fairbanks, AKN2753LMccartney Matthew T · Lake Tapps, WAN2753QFull Throttle Aviation LLC · Terlingua, TXN2753SSlownlow LLC · Kalispell, MTN2753VSirius Real Estate LLC · Murphys, CAN2753XStorer Charles E · Payette, ID
Back to AD 97-01-13