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.
N65BLWhite Craig S · Troy, OHN65CFSanders David T · Flagstaff, AZN65DGDeschweinitz Christian R · Anchorage, AKN65DPPilawski Darren · Spring Hill, FLN65DWNorth Stream Capital LLC · Scottsdale, AZN65EAPhilbrick Quinn R · Rangeley, MEN65EBKansas Farm & Ranch In · Seneca, KSN65FDBarnstormer Leasing LLC · Murfreesboro, TNN65GVDemski Domenic Ross · Woodbridge, CAN65HFHorizon Flight Center LLC · Chesapeake, VAN65JAJahawk Leasing LLC · Sugar Grove, ILN65KCBarr Air Patrol LLC · Mesquite, TXN65KDNorthwest Wings LLC · Hillsboro, ORN65KSSauceda Juan B · Austin, TXN65MArata Steve · Corning, CAN65MMShewbart Keith M · Crystal River, FLN65MPWard Gerald · Austin, TXN65NOlterman Robin L · John Day, ORN65PKOlson'S Excavating Inc · Cascade, IDN65PTBs Aviation LLC · Portland, ORN65RGRandolph Clinton A · Bullhead City, AZN65RHHall Robert · Rapid City, SDN65SKenyon Ray · Sherburne, NYN65WBMckamey Robert S · Tullahoma, TNN65WPWarnken James V · Pleasanton, TXN66003Nesheim William A · Holderness, NHN66006Registration Pending · Souderton, PARegistration pendingN66009Cowan Ronnie C · Glasgow, KYN6600DMarsh John E · Washington, DCN6600FSeiger Thomas W · Medford, ORN6600RDoyles Welding Lc · Phillipsburg, KSN6600TJtf Aviation LLC · River Falls, WIN6600XBlanton David L · Valley Center, KSN66010Crane William Jr · Somerville, ALN66015Rock Solid Aviation LLC · Lake Charles, LAN66017Engelhardt John · Kingwood, TXFirst renewal noticeN66018Executive Aviation LLC · Peoria, AZN6601EBiloff Chet A · Palmer, AKN6601HCanby Pilots Club Inc · Canby, MNN6601KAir Force Academy Aero Club · Usaf Academy, CON6601MOptical Aviation LLC · Edmond, OKN6601RHolmes Donald R · Carlsbad, CAN6601THoting John M · Santa Rosa, CAN66021Mcgraw Leasing LLC · Sitka, AKN66022Pickett Ronald K II · Mc Alpin, FLN66025Suburban Air Corp · Castro Valley, CAN6602CSnip Robert C · Telluride, CON6602DLand Of Liberty LLC · Seminole, FLN6602ERivera Joel · Carolina, PRN6602FBeasley Thomas · Fort Worth, TX
Back to AD 79-10-14 R1