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.
N6455VCrown Flying Club Inc · Olathe, KSN6455XGreat Basin Aviation LLC · Eagle River, AKN6456BVintage Trainers Inc · Wilmington, DEN6456FAmb Parnell G · Portland, NDN6456SBecker Richard Keith · Fraser, MIN6456UN909dw LLC · Helena, MTN6456VRosing David · Sunland, CAN6456XBurgess Mark W · Greene, MEN64575N64575 LLC · Cheyenne, WYN6457BJcb Holdings LLC · Helena, MTN6457DTristar Aviation Services LLC · Hendersonville, TNN6457ENewell Michael S · Marion, OHN6457FPepper Christopher W · Memphis, TXN6457GN19752 LLC · Toledo, WAN6457KWysong Henry D III · Kent, WAN6458AStebbins Robert B · Georgetown, TXN6458BChavez Lauren K Hollingsworth · Albuquerque, NMN6458FLejcar Matthew J · Mesa, AZN6458TContinental Title Trust LLC · Wichita, KSN6458VWilson David P · Lumberton, TXN6459CBallair LLC · Dalhart, TXN6459TRohlman Aaron · Republic, MON645EPChristiansen Aviation LLC · Wilmington, DEN645FCFlorida Dept Of Agriculure & Consumer Services · Tallahassee, FLN645PAzul Services LLC · Bozeman, MTN645PD150th Aero Flying Club · Morristown, NJN645SPRegistration Pending · Bennett, CORegistration pendingN645XAzul Services LLC · Bozeman, MTN645ZAzul Services LLC · Bozeman, MTN64608A S Air LLC · Lantana, FLN6460BSchmick Kenneth R · Fond Du Lac, WIN6460EHooks Herbert D · Templeton, PAN6460FThorton Rod W · Barrington, RIN6460HWhitetail LLC · Anchorage, AKN64611Great North Air LLC · Shelburne, NHN64617Melbourne Flight Training LLC · Melbourne, FLN6461GDrewry James D · Scottsboro, ALN6461VRegistered aircraftN6461XKrause Aviation LLC · Geneva, ILN6461ZJav Air Services LLC · Anchorage, AKN6462DN2893e LLC · Reno, NVN6462SRoss Mitchell B · Ledyard, CTN6462TAdkins George E · Brooklyn, IAN6462VVanbergen Shaun S · Ashland City, TNN6463ABiocca Richard · Tucson, AZN6463GTeens-In-Flight Inc · Palm Coast, FLN6463TKemmerling Lawrence W · Mazama, WAN6464BResicum International LLC DBA · Gulf Shores, ALN6464DHoney B LLC · Hillsboro, ORN6464EGeerlings Hillside Farms LLC · Holland, MI
Back to AD 79-10-14 R1