AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N60538Needs Nichole R · Granger, IAN6053ABalazs Marguerite · Devine, TXN6053GKaeser Robert E · Lafayette, INN6053RBowen Zackary · Dallas, TXN60545Lawson Chad D · Conway, SCN60546Stone Mark E · Winston Salem, NCN60548Mireles Cy M · Grapevine, TXN6054ABaker Travis L · Mount Pleasant, UTN6054RHobbs William A · Cornelius, ORN6054TWestrum Enterprises LLC · Norwalk, IAN60551Lawrence Erick D · Apache Junction, AZN60553Miller David · Albany, ORN60558Peder Richard A · Sequim, WAN6055FKlein Eric L · Tucson, AZN6055GStuckey Carl W · Collinsville, OKN6055TCampbell Glen · Phoenix, AZN60560Wright Matthew · Cincinnati, OHN60565Stansberry Gregory D · Greencastle, PAN60567Sale Reported · Moncks Corner, SCSale reportedN60568176fps LLC · Marthasville, MON60569Pelican Nethan B · Pineville, LAN6056FRkc Aviation Inc · Wilmington, DEN6056JAchord James D · Decatur, ALN6056RMission Aviation Training Academy · Arlington, WAN60572Newsom Rickey D · Springfield, ARN6057TFurlong Kelly · Athens, ALN60584Silva Christopher J · Sinking Spring, PAN60586Ramon Jackson · Ardmore, OKN60588Phoenix Service Corp · Highland, CAN6058GKowalis Christopher C · Katy, TXN6058JWhitson Freddie B · Llano, TXN60590Knowles Warren R · Ocean City, NJN60596Head John Tarpley Jr · Port St Joe, FLN60597Ritchie James E · Grand Junction, CON6059ABradley Jesse C · Sheridan, MIN6059DLong Island Aviators LLC · Seaford, NYN6059GBishop Elijah N · Montgomery, TXN6059RGlidewell Aviation Inc · Parkland, FLN6059TSible Andrew · Mckinleyville, CAN605EREmbry-Riddle Aeronautical University Inc · Prescott, AZN605MAAir Assets LLC · Orlando, FLN605NBRegistered aircraftN605NRState Of Minnesota · Grand Rapids, MNN605PMSky Baja LLC · Helena, MTN605SDMedary Aviation LLC · Brookings, SDN605WMZwl Consulting LLC · San Francisco, CAN60602Ratcliff Philip A · White City, ORN60603Christiansen Aviation LLC · Wilmington, DEN60607Resch Stephen · Fairfax, VAN6060APowers Michael E · Sierra Madre, CA
Back to AD 79-10-14 R1