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.
N2484JTundra Aviation Inc · Casselton, NDN2484LLuv2fly LLC · San Antonio, TXN2484UFiske James K · North Andover, MAN24856Mccreary Aviation LLC · Green Valley, AZN24857Pea-Wayman Flight LLC · Daytona Beach, FLN2485GBack Country Guys LLC · Prescott, AZN2485JPercival Sheila · Watson, ILN2485QPayne Scott M · Twin Bridges, MTN2485SBrewer Lester A · Magna, UTN2485YMcdonald Gregory S · Mena, ARN2486CArmstrong Patrick Trustee · Bishop, CAN2486GDenton Bob · Nampa, IDN2486RCain James W · Big Rapids, MIN2486SDarvek LLC · Las Vegas, NVN2486XGreat Escape Aviation LLC · Marquette, MIN2486YCarfinder LLC · Huntington Station, NYN24874Sunrise Aviation Inc · Ormond Beach, FLN2487GRegistration Pending · Aledo, TXRegistration pendingN2487RCummings Sean · Lombard, ILN2487SMoody Bible Institute Of Chicago · Spokane Valley, WAN2487UBaske Scott E · Hanna, INN2487YBradley Jeff C · Schertz, TXN24884Bravo Victor LLC · Afton, WYFirst renewal noticeN24886Warrior II Ltd · Des Plaines, ILN24887Sunrise Aviation Inc · Ormond Beach, FLN2488GRumley Orville C · Minco, OKN2488JMcdonald Nicholas W · Phoenix, AZN2488RCorprew Gerard A · Callao, VAN2488USchafer Gerhard Walter · Fairbanks, AKN2488XCentral Oil Co LLC · Mcminnville, TNN24895Lokker Dirk E · Oakdale, CAN2489CRegistered aircraftN2489GRogers Gregory J · Plesant Hill, MON2489JVan Velson Richard Lee · Brule, NEN2489LCalifornia Aviation Services Inc · Riverside, CAN2489UKauachi Melik · Brownsville, TXN2489XVanderweel Martha · Wolcott, NYN248BABering Air Inc · Nome, AKN248ERUnverferth Gregory T · Fort Jennings, OHN248GTHansen Nelse · Lawrenceville, GAN248KAKamaka Air LLC · Honolulu, HIN248PAPofolk Aviation Hawaii Inc · Honolulu, HIN248ZLightsey Aviation LLC · Jacksonville, FLN24908Hnatio Matthew J · South Deerfield, MAN2490JSchmitt Rudy · Brookshire, TXN2490LWimberly Thomas F III · Bend, ORN2490RBirdie Air LLC · Wichita, KSN2490UBredbenner Carl A · Dalmatia, PAN2490XFoley David A Trustee · Afton, WYN2491GShowah Christopher Douglas · Indianola, MS
Back to AD 97-01-13