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.
N2785UN2785u LLC · Hilton, NYN2786FChristoph Nicolas T · Okanogan, WAN2786GAvery John W · Fergus Falls, MNFirst renewal noticeN2786UBoos Daniel Paul · Jackson, WYN2786XRegistered aircraftN2787FWammen Gil V · Reva, SDN2787GGomez Bermudex Investments LLC · Lauderhill, FLN2787JLarson Jared E · Wasilla, AKN2787KWhirlwind Aviation Inc · Fisher, ARN2787LGateway Flying Club Inc · Saint Louis, MON2787QThorell Farms Inc · Loomis, NEN2787UNethery Autumn M · Shelbyville, KYN2788FShryock Patrick D · King Salmon, AKN2788GCaldwell Gregg P · Desert Hot Springs, CAN2788QKahle Matthew N · Paw Paw, MIN2789FHouck Joshua B · Wa Ct House, OHN2789JStephens Mark E Trustee · Morgan Hill, CAN2789LChurch Sammy H · Statesville, NCN2789QCenterline LLC · Yankton, SDN2789UKruse Russell E Jr · Siren, WIN278BDStubbs J Phillip · Richmond, VAN278CFInfinity Aviation LLC · Mandan, NDN278HJJohnson Joel P · Duluth, MNN278PBP21000318 Inc Trustee · Wilmington, DEN278SAInternational Air Services Inc Trustee · Carson City, NVN2790GBryan Roger J · Spearfish, SDN2790JLock Robert Allen · Grand Haven, MIN2790LWells Mark L · Eads, TNN2790QArthur Lloyd T · Greenfield, INN2791GHoutte Edmund Michael DBA · Palmer, AKN2791JPuget Sound Flyers Inc · Everett, WAN2792FRoshong Loman · Leesville, LAN2792GSpeedstar Aviation LLC · Kalispell, MTN2792JAndresen Leonard W · Anchorage, AKN2792QPalmer Paul F · Donnelly, IDN2793GMeyer Steven D · Snohomish, WAN2794GClark Jeremiah Jacob · Pleasant Plains, ARN2794JRegistration Pending · Anchorage, AKRegistration pendingN2794QVincer Way LLC · Centennial, CON2795FSmith Casey T · Marietta, GAN2795JEndeavour Flight Training Inc · Miami, FLN2795LHarkness Paul E · Richmond Hill, GAN2795URichardson Robert S · Austin, TXN2796FX-Ray Engineering Corp · Port Orange, FLN2796GDouglas Cattle LLC · Douglas, AZN2796LSmyth Michael L · Saint Charles, MON2797EPalm Beach Flyers LLC · Boca Raton, FLN2797FWhatley Charles J · Goliad, TXN2797JAlaska Ultimate Safaris LLC · Homer, AKN2798CStone Aviation LLC · Sacramento, CA
Back to AD 97-01-13