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.
N24512Moran Erick A · Orange, CAN2451CWilliams Marc Alomzo · Fallon, NVN2451FMontana Rose 185 LLC · Cornwall, VTN2451GHerring Gary A · Elverson, PAN2451LSky K Inc · Wilmington, DEN2451QAviation Mission 3:16 LLC · White Lake, MIN24522Wings Over Texas Holdings LLC · Denton, TXN2452FPesicka Theodore J · Hermiston, ORN2452QCallihan Richard L · Manning, SCN2452RKnutson Wayne R · Thompson, NDN2452UPuryear Rodney K · Pampa, TXN24530Mayfield Jon David · Dublin, TXN24532Christiansen Aviation LLC · Wilmington, DEN2453CFoster Steven W · Big Lake, AKN2453FSooter Shem · Juneau, AKN2453GPeloquin William A · Portland, MIN2453QHarris Rand · Camas, WAN2453YNoteboom-Hegg LLC · Sioux Falls, SDN24544Comer Dwayne M · Glendale, AZN24546Valestin Donald P · Queen Creek, AZN2454LFulbright Steven R · Prineville, ORN2454QTracemont Flyers LLC · Boyce, LAN2454RBrown Timothy L · Liberty Lake, WAN2454XShiflett Tyrell · Deming, NMN24553Jensen Aviation LLC · Rancho Cucamonga, CAN2455QVan Diepen Thomas · Baker City, ORN2455RLaw John · Marina, CAN2455YAircrafters French Valley Inc · Winchester, CAN2456R5625t LLC · Little Falls, NYN2456XBennett Annelise · Granbury, TXN24579Grunwaldt Peter J · Anchorage, AKN2457ERegistered aircraftN2457FPettyjohn Nancy Paulette Sautebien · Dearborn, MIN2457RPicotte Paul C · Fallon, NVN2457SAviation Specialty Services LLC · Beaufort, NCN2457UBurr Ronald E · Anchorage, AKN2457YGhost Rider Aviation LLC · Yuma, AZN2458CGant Dallas C Jr · Wickenburg, AZN2458FErickson Timothy M · Mead, NEN2458LBowman Joseph F · Flora, MSN2458UEversoll Dennis D · Petersburg, INN2458XMountain City Flying Club Inc · Hazle Township, PAN2458YArdmore Aviation LLC · Novelty, OHN2459CAkchak Air LLC · Leeds, UTN2459LMedia Stew LLC · Carson City, NVN2459RGardiner Timothy M · Gardendale, ALN2459UHaynes Harrison F · Gainesville, GAN245BMBen-Hur Air Chariots LLC · Fort Myers, FLN245CRBlue Eagle Aviation LLC · Danville, CAN245FRChupito Sabrocito LLC · Paso Robles, CA
Back to AD 97-01-13