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.
N6505GStern Scot G · Escondido, CAN6505N3c3 Aviation Inc · Dania Beach, FLN65065Angel Aviation Inc · Peoria, AZN6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTN6506EArmstrong Bruce · Port Orchard, WAN6506FMdowell Pilot Service LLC · South Hutchinson, KSN6506GWestern Skyways Inc · Montrose, CON6506MBeechhurst Corp · Wilmington, DEN6506VHarper Dreams LLC · New Smyrna Beach, FLN6506XBas Part Sales LLC · Greeley, CON6506ZAf Auto Group · San Jose, CAN6507XBailey Scott D · Ione, CAN6508HBkb Inc · Newport, MIN6508KTroy Oakland Pilots Flying Club Inc · Troy, MIN6508TManchester Eric S · Milton, VTN65093Seaman Michael V · Kalispell, MTFirst renewal noticeN6509GMehling Robert C · Hardin, MTN6509HSale Reported · Benton, KSSale reportedN650VVMindy Limited LLC · Muscatine, IAN65107Renforth Michael E · Yorktown, VAN6510EScherer Luis R · Kent, OHN6510FPrice Gregory L · Kyle, TXN6510XSteinbroner Daniel J · Lawton, OKN65112Jav Air Services LLC · Anchorage, AKN6511EMckenna Francis · Granville, PAN6511GBuerk James R · Smethport, PAN6511SGby Aero LLC · Cocoa, FLN6511VSc Skywalker Aviation LLC · West Sacramento, CAN6512DCajun Wings LLC · Bourg, LAN6512GParry Anthony D · Sedro Woolley, WAN6512HOrganization Of Black Aerospace Professionals Inc · Olive Branch, MSN6512KLoomis Aviation LLC · Columbus, OHN6512SHaskin Jeff · Sulphur Springs, TXN6512TJestes Monte G · Stillwater, OKN6513DGhia Flying Venture LLC · Scottsdale, AZN6514JJuggernautaviation LLC · Lewes, DEN6515GNorthwest Aeroventures LLC · Steilacoom, WAN6515SMoroney Richard D · Mc Grath, MNN6515XDauenhauer Steven M · Springtown, TXFirst renewal noticeN6516SLee Robert E · Medford, WIN6516TMiller Shawn C · Milaca, MNN65172Kfam Enterprises LLC · Dover, DEN6517APeterson Holding Co · San Leandro, CAN6517DSlaboszewski Donald W Jr · Joliet, ILN6517ERed Baron LLC · Middletown, DEN6517FSnouffer Robert E · Mountain Grove, MON65180Mccraw Bryan · Telephone, TXN6518EMozingo James C · Hernando, FLN6518TMcclintock Matthew · Oscoda, MIN65191Bampton Dennis · Portage Des Sioux, MO
Back to AD 79-10-14 R1