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.
N8299ELondon Corbin Airport Board · London, KYN8299SMcauliffe John P · Livonia, MIN8299XBeail Herschel D · Quincy, CAN829AFAmeriflyers Of Texas Inc · Addison, TXN829BGGipson Robert E · Port Byron, ILN829BWBridgewater State University · Bridgewater, MAN829CPCivil Air Patrol · Maxwell Afb, ALN829EREmbry Riddle Aeronautical University · Daytona Beach, FLN829FACareer Flight Training And Aircraft Rental Holding · Naples, FLN829FSPerformance Aircraft Sales Inc · Lincoln, NEN829PJMidwestern Twang Communications LLC · Evanston, ILN82ADAdams Aircraft LLC · Wilmington, DEN82BAMcilnay Brian S · Athens, TNN82BGGrimshaw Brian Trustee · Long Beach, CAN82CCDenrow Limited Lc · Shawnee, OKN82CTCoelho Gabriel P · Chowchilla, CAN82DZJosephine Air LLC · Castle Rock, WAN82ESkymaster Mods & Parts LLC · Castalian Springs, TNN82EDRodriguez Rolando · Harlingen, TXN82EPPosav Holdings LLC · Zephyrhills, FLN82FBBolea Air Inc · Morgan Hill, CAN82FLVan Bortel Aircraft Inc · Arlington, TXN82HABeller Ronald D · Morehead, KYN82HSAdventist World Aviation · Wilson, NCN82JDJ D Aviation LLC · Rochester, NYN82JWGaines Joseph M · Niceville, FLN82KCDrake Raymond H · Asheville, NCN82KYKentucky Department Of Aviation · Frankfort, KYN82LAAvery Lyle · Beach Lake, PAN82LECollier County Sheriffs Office · Naples, FLN82LTRegistered aircraftN82LWMuskox Ministries · Fairbanks, AKN82MEHutt George H III · Stratham, NHN82MGSkymasters LLC · Olathe, KSN82MHRainier Flight Service LLC · Renton, WAN82MNDodson International Parts Inc · Rantoul, KSN82NGallant James II · Scottsville, KYN82NACoduto Billy Mark · Shelbyville, TNN82PAHart Michael Anthony · Rockford, ILFirst renewal noticeN82SLHanus Logan D · Kenyon, MNN82TLRegistration Pending · Roscoe, ILRegistration pending, pending cancellationN82WAVomela Paul Trustee · Wasilla, AKN82WGHash Brian Morrison · Mattawa, WAN82XTPerreault Mark L · Van Buren, MEN82YMiller Charles G · Anchorage, AKN82YCBerry Kevin J · Renfrew, PAN8300AChapa Jana K · Corpus Christi, TXN8300BMonger Kenneth R · Bella Vista, ARN8300MWiener Ronald K Trustee · Tucson, AZN8300QSafeco Leasing LLC · Port Alsworth, AK
Back to AD 79-10-14 R1