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.
N7453TEllis Wendell Kirk · Gakona, AKN7453XMccoy Rileigh N · Conway, ARN7454AMoore Robert L · Anderson, CAN7454GDaniel Dewey R · Okeechobee, FLN7454MSteier Tim A · Salome, AZN7454QHattieville Leasing LLC · Morrilton, ARN7455AApplied Products LLC · Grove, OKN7455THowes Roger W · Hinckley, UTN7455XAsher Jerry R · Speedwell, TNN7456TWalker Chad E · Denton, NCN7456XHanson Devan D · Stephenville, TXN7457AHottenstein John C · Rifle, CON7457MThigpen Jacob T · Adkins, TXN7457QThompson Erick O · South Jordan, UTN7457SDee Matt · Saint Petersburg, FLN7458ARegistration Pending · Waynesville, OHRegistration pendingN7458FTorode John Q · Hunts Point, WAN7458MMcgowin Barry · Sylacauga, ALN7459MReel Chad A · Wasilla, AKN7459QBeemer David A · Bath, MEN7459TBurrows Nicholas J · Daytona Beach, FLN7459XMccormick Gary E · Fairbanks, AKN745AGJ&M California Land Company Inc · Bakersfield, CAN745ASA2g International LLC · San Juan Capo, CAN745BPlanelease LLC · Venice, CAN745BACsa Aircraft Leasing LLC · Salt Lake City, UTN745CPCivil Air Patrol · Maxwell Afb, ALN745DCN745dc LLC · Kennesaw, GAN745EREmbry-Riddle Aeronautical University Inc · Prescott, AZN745KPPaklook Air Inc Dbi · Bethel, AKFirst renewal noticeN745NDornoch Services LLC · Dover, DEN745SPBanks Douglas Trent III · Huntsville, ALN745TWTumbleweed Leasing Co Inc · Salt Lake City, UTN745UDornoch Services LLC · Dover, DEN745XColson Troy D · Crystal River, FLN745ZZin Services LLC · Dover, DEN7460GHelping 24 Hours LLC · Goodyear, AZN7460TJones Andrew G · Terrell, TXN7461AJohnson Jeffrey M · Versailles, KYN7461GKniphfer Krenson Hunter · Newington, GAN7461XIsert Brian · Melba, IDN7462ABenallo Joseph D · Homer, AKN7462MRegistered aircraftN7462SG2 Aviation LLC · Dublin, GAN7462XSheehan Michael · Canton, GAN7463AVandenbelt Kenneth J · Leslie, MIN7463MRothgeb Michael A · Ketchum, IDN7463QDelaney David M · Bullard, TXN7463TCurp Christopher A · San Jose, CAN7463XGillespie William G · Antioch, CA
Back to AD 79-10-14 R1