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.
N735AWDesert Dog Signs LLC · Ogden, UTN735AXState Of North Carolina · Raleigh, NCN735AYFlight LLC · Las Vegas, NVN735AZYellowstone Aviation Inc · Jackson, WYN735BAWheels Up Aviation Inc · Arlington Heights, ILN735BESmith Cullen M · Framingham, MAN735BFMedvigy Gary A Trustee · Camas, WAN735BHEfinger John M · Cresson, TXN735BJSpirit Avionics Ltd · Gahanna, OHN735BLThomas John D · Jasper, TNN735BPMacon Air LLC · Franklin, NCN735BQSayre Daniel E · Mckinleyville, CAN735BRCooper Kevin J · Kingsport, TNN735BTPtmm LLC · Columbus, OHN735BULinebarger Daniel R · Granbury, TXN735BWWilliams Frank · Kerrville, TXN735BXRajotte Leith Gaines · Hood River, ORN735BYRegistered aircraftN735BZBuckner Steven W · Gatesville, TXN735CCHardeman Brian · Manhattan, KSN735CEKangas Randy P · Fairbanks, AKN735CFG & M Aircraft Inc · Wheat Ridge, CON735CGBumpah Aviation LLC · Ardmore, OKN735CHMckelvey Charles Y · Little Egg Harbor, NJN735CJNorthgate Aviation LLC · San Antonio, TXN735CKLickety-Split LLC · Celebration, FLN735CLSprinkler Shop Inc · Paul, IDN735CQKanaps LLC · Huntsville, ALN735CRMcdaniel Erick · Fort Worth, TXN735CSGoldsky 1 LLC · Maitland, FLN735CUGross Thomas E · Mooresville, NCN735CVYocham Scott · Mcgregor, TXN735CXInternational Air Services Inc Trustee · Carson City, NVN735CYSocal Aviators LLC · Fullerton, CAN735CZPearl 3022 LLC · Lady Lake, FLN735DBSailsbery Brett E · San Clemente, CAN735DCWysocki Alice R · Ellington, CTN735DFHd Legacy LLC · Richvale, CAN735DGEricson Jay S · Eagan, MNN735DJPinckert Thomas · Potomac, MDN735DKGraziani Frank L · Hot Springs, ARFirst renewal noticeN735DLGeorge Robert C · Woodway, TXN735DNState Of North Carolina · Raleigh, NCN735DQCampbell James T · Astoria, ORN735DUCarmel Aviation Inc · Boise, IDN735DVRed Baron Flyes Inc · Caledonia, MNN735DXSantamaria Joseph J · Hebron, NHN735DYRegistered aircraftN735EACivil Air Patrol · Maxwell Afb, ALN735EBSpohn Craig C · Shreveport, LA
Back to AD 79-10-14 R1