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.
N54589Twin City Cloud 7 Inc · Eden Prairie, MNN5458RLafranchise Louis C · Aurora, ORN5458TTodd Tyler L · Quitman, MSN5459BBonnell Aaron K · Orland Park, ILN5459CWatkins George T · Spokane Valley, WAN5459HWard John W · Troutdale, ORN5459JKling Aviation Inc · Friendswood, TXN5459KPropability One LLC · Daytona Beach, FLN5459QZimmerman Dean F · Royalton, MNN5459RAllsup Rachel B · Anchorage, AKN5459TBrennan Brian L · Tipton, IAN545BLJaeger Stacey K · Towner, NDN545DHaskell Corporation · Bellingham, WAN545DSAero Maintenance Inc · Vancouver, WAN545DTSkahill Earl DBA · Denver, CON545FCatching Freedom LLC · Bozeman, MTN545FAJb Aircraft LLC · Anchorage, AKN545KSKent State University · Stow, OHN545MCBarnes Robert Edward Jr · Mason, OHN545ML3rd Coast Air LLC · Traverse City, MIN545NDChristiansen Aviation LLC · Wilmington, DEN545PSUnited States Department Of The Interior · Boise, IDN545PZLake Placid Flying Service Inc · Lake Placid, NYN545QCatching Freedom LLC · Bozeman, MTN545TMSmall Mark A · Laveen, AZN545UCatching Freedom LLC · Bozeman, MTN545WKenmore Crew Leasing Inc Trustee · Bellingham, WAN545YCatching Freedom LLC · Bozeman, MTN545ZDornoch Services LLC · Dover, DEN5460QJacobson Eric R · Ouray, CON5460RTake Angels Aviation LLC · Watertown, NYN5460SMatanane Roke C · Barrigada, GUN54618Sandstrom Allan A · North Ogden, UTN5461KFaragallah Allan A · Garden Grove, CAN5461XState Of Alaska · Anchorage, AKN54626Continental Title Trust LLC Trustee · Wichita, KSN54628Ohio State University · Columbus, OHN5462QLeading Edge Flight Academy LLC · Bend, ORN5462RJameson Fred · Rathdrum, IDN54633Warner Walter M · Willow, AKN54634Savannah Airplane Venture LLC · Myrtle Beach, SCN54635Memphis Navy Flying Club · Millington, TNN5463JMachado Joe L · Tucson, AZN5463KRick Aviation Inc · Newport News, VAN5463NM Sipolt Air LLC · Paradise Valley, AZN5463SPlanzer Henry L · Dalton, GAN5463TFrazier Isaiah V · Blue River, WIN54646Jordao Isabella C · Oklaunion, TXN5464CKlockner Charles R · Waterford, WIN5464DJprg Aviation Inc · Orlando, FL
Back to AD 79-10-14 R1