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.
N786CPWings Over Texas Holdings LLC · Denton, TXN786DPHensley Terry Jr · Sterling, AKN786ERTextron Aviation Inc · Wichita, KSN786FAAb Prop Plane II LLC · Metairie, LAN786FGRidgeline Assets LLC · Wilmington, DEN786JHButler Carol J · Anchorage, AKFirst renewal noticeN786SAGulf Aviation Holdings I LLC · Seattle, WAN786SPDevacana Transport Ltd · Lewes, DEN786TFAmerican Corporate Executive Services · Plantation, FLN7870AMerriman John R · Georges Mills, NHN7870EConner Walter L · Los Lunas, NMN7870NUnited States Air Force Owner · Colorado Springs, CON7870ZNp Aviation LLC · Boulder, CON78710Flying 64th Inc · Oak Ridge, TNN78711Swartwood Thomas · Everson, WAN78716Rhodes Sanford E · Odessa, TXN78718Aircraft 1821 LLC · North Charleston, SCN7871ACantrell Dennis Owner · Conway, ARN7871EValentine Barry L · Brunswick, MEN7871TPeters Harold B · Weirsdale, FLN78720Sale Reported · Greeley, COSale reportedN78721Aquino Rogelio M · Cliffside Park, NJN78729Copper Country Flyers Inc · Oconto, WIN7872GAmerican Classic Flying Club LLC · Waterville, MEN7872NUnited States Air Force Owner · Holloman Afb, NMN7872USwanson Donald W · La Center, WAN78733Garden Spot Flyers · Manheim, PAN78737Meyer Rex · Harmon, ILN7873NUnited States Air Force · Colorado Springs, CON78747Green Matthew M · Turlock, CAN7874FLynch Cody J · Stanwood, WAN7874GLa Porta John R · Des Moines, WAN7874J2f Trade LLC · Collinsville, TXN7874NUnited States Air Force Owner · Colorado Springs, CON7874TReisinger Thomas P · Browerville, MNN7874UWeinzel Victor · Willis, TXN7874XPope Bradley L · Woodstock, GAN78757Hooten Bonnie Bryan · Tifton, GAN7875FDeffendall Cathy S · Florissant, MON7875GRegistration Pending · Helena, MTRegistration pending, pending cancellationN7875UStevens John · Hernando, FLN7875XMartin Tommy L · Vancouver, WAN78760Jakus Matthew Thomas Trustee · Parowan, UTN78763Steve'S Landavator Service LLC · Oley, PAN78766Boyle Dale L · Woodward, OKN7876FSavedge A Randolph · Surry, VAN7876TRoberts Gary W · Friday Harbor, WAN7876UGold Coast Flight Service LLC · Camarillo, CAN7876XKotrla Claren J · Hilltop Lakes, TXN7877FCosta Air Service LLC · Painted Post, NY
Back to AD 79-10-14 R1