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.
N20056Haney Randall M · Boaz, ALN20057Opiela Robert M · Hampton, NHN20058Ballou Skies Aviation Inc · Bucyrus, OHN20059Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN2005GGreat Basin Aviation LLC · Eagle River, AKN2005QCoon Roger E · Springtown, TXFirst renewal noticeN2005XTurnmire Jeffry B · Knoxville, TNN20060Bakken George S · Terre Haute, INN200617b Flying Club Inc · Sandpoint, IDN20063Beery Milo A DBA · Clarinda, IAN20065Southern Aero LLC · Homestead, FLN20068Spartanburg Area Flight Education LLC · Spartanburg, SCN20069Montel Richard D · Candler, NCN2006GYates Rodney R · Hubbard, ORN2006QFarr Brad L · Uvalde, TXN2006RBarclay Mechanical Services Of Utah Inc · Manti, UTN2006ZN2006z LLC · South Hill, VAN20070Skywarrior Flight Training LLC · Pensacola, FLN20071Limaoscar LLC · Boca Raton, FLN20072Ace Aviation 20072 LLC · Pembroke Pines, FLN20073Gulf Coast Aviators LLC · Venice, FLN20074Kyzer Aviation Holdings LLC · Fort Mill, SCN20079Celestial Kinetics Flight Academy LLC · Waupaca, WIN2007QHopkins William · Reno, NVN2007RDoc'S Flying Club LLC · Macon, GAN2007TWinger Raymond E · Johnson, KSN2007UBank Of Utah Trustee · Salt Lake City, UTN2007YFoster Lemuel E · Vancouver, WAN2007ZRau John M · Liberty, KSN20085Fleming Ian · Peoria, AZN20089Eagle Air Inc · Schoolcraft, MIN2008GChaump Michael · Reno, NVN2008QCoulter Dennis · Lincoln, CAN20091Henderson Norman L · Bowling Green, MON20093Patterson Kyle · Tega Cay, SCN20094Valiair Lc Trustee · Casper, WYN20095Wingsleasing LLC · Wichita, KSN20097Morrison Robert J · Newport, MIN20099Wehnam Kenneth J · Shingle Springs, CAN2009QTranby Wayne A · Fargo, NDN200AARad Runner LLC · Newton, NCN200BJWright Thomas L · Clyde, OHN200BNRubber Duck Aviation LLC · Brunswick, GAN200DCBjg Aviation I LLC · Neelyville, MON200EKBw Air LLC · Pierre, SDN200GCDancy Abram P · Shrewsbury, MAN200HPOklahoma Department Of Public Safety · Norman, OKN200KSKapowsin Air Sports Ltd · Shelton, WAN200LDFenske Jeffrey D · Gold Hill, ORN200LFAeromarine Holdings LLC · Waukesha, WI
Back to AD 97-01-13