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.
N3224CHassebrock John M · Colorado Springs, CON3224DE W Aircraft LLC · Manhattan, MTN3224SSkylane Trio Ltd · La Junta, CON3224YCrouchet Jay · Kremlin, MTN3225LWing Nuts Inc · Maryville, MON3225UBlizzard Air LLC · Midland, TXN3225YSamaritans Purse · Boone, NCN3226LStammen Dakota J · Stanley, NDN3226SJones David A · Wasilla, AKN3226YVaughn William Harrison · San Antonio, TXN3227ABoho LLC · Lewes, DEN3227CSnider Frederick A Jr · Morgantown, WVN3227E3227e LLC · Jacksonville, FLN3227JCanepa Joseph H · Baraboo, WIN3227LLown Robin F · Douglas, AKN32282Watson Scott E · Wichita, KSN3228DNulsen Eric Randall · Greenbrier, ARN3228LWoodson Marcus L · Detroit, MIN3228UTnt Rentals LLC · Wilmington, DEN3228YFawley John M · Wisconsin Rapids, WIN3229LTate Samuel Paul Baylon · Tacoma, WAN3229UEdwards Scott A · Lindsay, CAN322BFVann Russell B · Mangum, OKN322HAAir Flight Inc · Fort Lauderdale, FLN322KDI Fly High Flight Services LLC · Lovejoy, GAN322PHCafferty Associates Inc · Sarasota, FLN322QBCaine Timothy · Bend, ORN322RMPhillips George Thomas · Carson City, NVN322TNExecutive Wings LLC · Bolivar, TNN322WRBabineaux Kenneth W · Porter, TXN3230JEastside Aero Inc · Eatonville, WAN3230TLsao LLC · Shelbyville, ILN3230YCosta Flying Service Inc · Painted Post, NYN3231DMcfarlane Claude L · Fitchburg, WIN3231LColumbia Asset Trust Corp Trustee · Wichita, KSN3231TGouse Frederick Earl II · Waxahachie, TXN3231VDariz Natascha Y · Mount Laurel, NJN3232DZucchero David M · Stanwood, WAN3232XBitikofer Brent E · Kansas City, KSN3232YWise Frederick W · Windsor, PAN3233SVan Ness James A · Buckley, WAN3233XNollau Gregory P · Big Bear City, CAN3233YShepperson Ranch Co · Midwest, WYN3234YGrefsrud Travis · Pelican Rapids, MNN3235SPollard Brent H · Wilburton, OKN3236DFrey Joseph · Fallon, NVN3236JWoehler Keith A · Bardstown, KYN3236LMartin Alan K · Tenaha, TXN3236MManning Daniel E · Posen, MIN3236UHetrick Daniel R · Orovada, NV
Back to AD 97-01-13