AD 2012-17-06
Registered aircraft · 2,157
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:2012-17-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-06')
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:2012-17-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-17-06') 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.
N456PBooth Donald V · Denison, TXN45888D-Five Holdings Group LLC · Vidor, TXN45MBWright Kelly A · Spokane, WAN46MJones Gregory D · Pueblo, CON46PHarrison Donna J · Eau Claire, MIN478WTBas Part Sales LLC · Greeley, CON47BBRogers Joseph O III · Fernandina Beach, FLN487SCRegistered aircraftN4960250 Inc · Washington, DCN4995BStobbe Marlin L · Granada Hills, CAN4CBDream Catcher Company LLC · Center, CON4PLJuliet Kilo Aviation LLC · Palos Heights, ILN4XNMiller Donald W · Harrisonburg, VAN5002POrtman Bernard · Deer Park, TXN5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeN5005PRackley William R Jr · Grand Island, FLN5006PWright William · Cleveland, OKN5008PThree Chicks Aviation LLC · Benton, LAN500AVInternational Air Services Inc Trustee · Carson City, NVN500PFord Charles D · Clifton, TNN5014PSky Valley Aviation LLC · Waverly, IAN5017PPineapple Air LLC · Wilmington, DEN5020PThurston Steven C · Salisbury, NCN5029PJordan Walter B · Chehalis, WAN5034PNeufeld William J · Bostwick, FLN503JALiem David H · Brea, CAN5045PMccarty Paul S · Wichita, KSN5048PBrown Mark E · Charlotte, NCN5050PBoucher Bobbi · Fredericksburg, VAN5051PGrorud James R · Milbank, SDN5058PBakeman Michael G · Sturgis, MIN505BJLa Beau Lawrence O · San Angelo, TXN5065PVeal Ted W · Homer, AKN5066PDelaware Aviation LLC · Sidney, NYN5074PShingledecker Robert K II · Ozark, ARN5078PPutnam Andrew L · New Limerick, MEN5088PKesser Gilbert M · Culpeper, VAN5091PSpicuzza Robert A · Waterford, MIN5093PAir Chutney LLC · Waynesboro, VAN5099PSelinger Richard L · Murrieta, CAN5100PHuntcliff Air Services LLC · Atlanta, GAN5107PStranton Air LLC · Harvard, ILN5114PParris David T · Virginia Beach, VAN5115PSmith James Kelly · Newark, OHN5117PMarsteller Michael A · Lugoff, SCN5118PMeng Marvin Allen Jr · Edwardsville, ILN5126PElie Jonathan · Hopewell Junction, NYN5128PSchafer David · Northport, ALN5130PWhite Guy B · Waxahachie, TXN5132PMccormick Geoffrey D · Goodyear, AZ
Back to AD 2012-17-06