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.
N2434CGoad Graham L · Mcminnville, ORN2434FHanson Inc · Kalispell, MTN2434JSkyhawk Aero LLC · Montevideo, MNN2434LWeston Torey C · Unionville, MON2434USkyhawk N2434u LLC · Wilmington, DEN2434XJensen Shaun V · Anchorage, AKN24351426th Aero Squadron LLC · Cropwell, ALN2435FBas Part Sales LLC · Greeley, CON2435GVoninski John R · Manlius, NYN2435JWitherspoon Jason C · Austin, ARN2435LAero Science International LLC · Augusta, GAN2435QVolare Aviation LLC · Wylie, TXN2435UGalati Stephen E · Florissant, MON24363Sale Reported · Crystal, MNSale reported, canceledN24364Monsalve Carlos M · Lewiston, NYN2436CHawk Unlimited LLC · Kalispell, MTN2436GDk Futures LLC · Reno, NVN2436RSilva Gary · Yerington, NVN2436SCranney Dan Gordon · Sevier, UTN24373Hillsboro Aero Academy LLC · Hillsboro, ORN2437CFogleman Brian L · Stonewall, LAN2437FKuersten Robert S · Middleton, WIN2437RBlackwelder John W · Columbia, KYN2437XLudke Arnold · Oakland, NJN2437YRussell John D · Dana Point, CAN24385Laurel Highlands Aeronautical Academy · Latrobe, PAN2438GWk Aviation LLC · Buffalo, SDN2438JVayner Anton · Shorewood, WIN2438UThweatt Greg K · Lodi, CAN2438XRousser Cattle LLC · Amarillo, TXN2438YHoskins Aaron C · Cayuga, NYN24399Lcc North LLC · Freehold, NJN2439GJ+J Electric LLC · Seminole, TXN2439JHenderickson Robert T · Galesburg, ILN2439LBetts William B · Big Lake, AKN2439USmith Steven T · Charlottesville, VAN2439XAlpha Aero LLC · Biddle, MTN2439YBluegate Engineering LLC · Richburg, SCN243MBSwanson Timothy J · Bannister, MIN243PWTexas Parks And Wildlife Department · Austin, TXN243WMoore William · Dalhart, TXN244004 One Air LLC · Holland, MIN24403Somboonsap Patanapong · Oakland Park, FLN2440JOliver Tim J · San Luis Obispo, CAN2440LEads Kevin C · Arley, ALN2440UMiller Patrick · Madison, MNN2440YMorristown Flying Service Inc · Talbott, TNN2441RBelly Acres Capital And Management LLC · Memphis, TNN2442CRoberts Calvin · Bluebell, UTN2442EExecutive Flyers Inc · Sacramento, CA
Back to AD 97-01-13