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.
N7750XBurklund Joel H · Minneapolis, MNN7751KKyer Barry P · Honey Grove, TXN7751LU S Air Force Owner · Beale Afb, CAN7751TBehl Nathan S · Lewistown, MTN7751VGoodman Matthew R · Kenly, NCN7752EKountz Harvey J · Brockway, MTN7752FBoulware James Curtis · New Smyrna Beach, FLN7752LUnited States Airforce Owner · Albuquerque, NMN7752XCassell Peter B Jr · Stonewall, LAN7753GCw Enterprise LLC · Jewell Ridge, VAN7753LUnited States Air Force · Usaf Academy, CON7753THollis Scott C · Sumpter, ORN7753UAmyx Hiram R · Liberty, TXN7754EBurns Robert M III · Columbia, SCN7754GRegistration Pending · Sioux Falls, SDRegistration pendingN7754LUnited States Air Force · U S A F Academy, CON7754XKendall David · Ferndale, CAN77551Otto Robert E · Battle Ground, WAN77554U S Department Of The Interior · Boise, IDN7755ADunn Brian R · Otis, MEN7755FHayhurst Shane R · Winfield, PAFirst renewal noticeN7755GSagori Aviation LLC · Orlando, FLN7755LUnited States Air Force · U S A F Academy, CON7756GDedalis Emory A · Colts Neck, NJN7756LUnited States Air Force · U S A F Academy, CON7756UReid Wayne P Jr · Yucaipa, CAN7756XSkelton Air LLC · Lewiston, IDN7757CBentley John R · Bend, ORN7757EIvanchenko Sergey · Phoenix, AZN7757LUnited States Air Force · Usaf Academy, CON7757THarris Seth · Ellensburg, WAN7757UTruitt Seth L · Cynthiana, KYN7758EShannon Jon M · Conroe, TXN7758GGallo Enterprises Inc · Wonder Lake, ILN7758TWorringer Richard G · Tower, MNN7758XHewitt Chad R · Vernonia, ORN7759TMartin Douglas A · Bartlett, ILN7759UButts Alex D · Douglassville, PAN775CPCivil Air Patrol · Maxwell Afb, ALN775GTToole Gregory Keith · Humble, TXN775JDPolakewich Gerald F · Biddeford, MEN775LAColumbia Leasing LLC · Hillsboro, ORN775MCAmerican Patrols Inc · Midland, TXN775MRTorres Kim Renee · Castroville, TXN775PSkydive Seneca Lake LLC · Ovid, NYN775PSCrop Jet Aviation LLC · Gooding, IDN775RTG & M Aircraft Inc · Wheat Ridge, CON775SP775sp LLC · Blaine, MNN775WBSusanville Aviation LLC · Susanville, CAN7760CSosa Leonardo Correa Luna · Stillwater, MN
Back to AD 79-10-14 R1