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.
N2105YLulays Aviation LLC · Salem, ORN2105ZErickson Bernard R · Saint Cloud, MNN21064Kelly John M · Gastonia, NCN21074Church Brian Lee · Del Mar, CAN2107FRymski Daniel L · Colorado Springs, CON2107RDickman Steve · Anchorage, AKN2107YOsborne Daniel M · Vero Beach, FLN21082Bolder Services LLC · Broomfield, CON21085Cundiff Hugh A · Clinton, NCN21087Estes Marine LLC · Fort Lauderdale, FLN21088Sky Cardinal LLC · Rancho Santa Fe, CAN2108ERedstone Arsenal Flying Activity · Redstone Arsenal, ALN2108RWard Neal Cpas Pc · Scottsdale, AZN2108URoy Roland P · Lewiston, MEN2108YNorthwest Wings LLC · Hillsboro, ORN21093Matson John R · Stoughton, WIN21096Ballard Gregg A · Cedar City, UTN21097Atb Aviation LLC · Wilmington, DEN21099Ricke Ryan · Hutchinson, MNN2109RVilt Jared J · Phelan, CAN2109YSnyder Chris · Olean, NYN210ADUniplane Inc Trustee · Wilmington, DEN210AKMaxinkuckee Aviation LLC · Columbus, INN210ANCalifornia In Nice Inc · San Jose, CAN210APRegistration Pending · Wilmington, DERegistration pendingN210ATTeeters David A · Salinas, CAN210AWJohnson Matt R · Fox Island, WAN210BBCherry Hill Aviation C182 LLC · Freetown, INN210BESouthern Aircraft Consultancy Inc Trustee · Casper, WYN210BGTurner Kenneth W · Arlington, WAN210BJSummers Equipment Leasing Inc · Wilmington, DEN210BNBy Land Air And Sea LLC · Alto, MIN210BTGood Aviation LLC · Oshkosh, WIN210BVPlane Fun Inc Tr Trustee · Snellville, GAN210BWSc & Dss LLC · Mckinney, TXN210BXNova Aircraft Holdings Inc · San Diego, CAN210CJettech Holdings LLC · Broomfield, CON210CEMaas Aviation LLC · Pewaukee, WIN210CHOne Up LLC · Stuttgart, ARN210CPToeppen Chris P · Atherton, CAN210CUTcl Fbo LLC · Tuscaloosa, ALN210CWBeach Partnership LLC · Myrtle Beach, SCN210DCRrr Land & Cattle Co LLC · Midland, TXN210DDDwoskin David F Trustee · San Pedro, CAN210DGWashburn Stig K · Westminster, MAN210DLDaneco LLC · Houma, LAN210DNMartin John J · Honesdale, PAN210DWBlomberg Nicholas R · Macon, MON210EBas Part Sales LLC · Greeley, CON210EAFollis Allen J · San Tan Valley, AZFirst renewal notice
Back to AD 97-01-13