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.
N75722Pt Real Estate Inc · Port Hadlock, WAN75724Lenamond L Don Jr · Anchorage, AKN75726Don Davis Aviation Inc · Henderson, KYN75727Silverhawk Aviation Academy Oregon LLC · Ontario, ORN7572TFlying Colors Airparts Inc · Leesburg, FLN7572UAirfrank Inc · Hackensack, NJN7572VOffshore Services Ltd · Block Island, RIN75731Ziegler Carl F · Forest Lake, MNN75733Red Door Aviation LLC · Dover, DEN75739Entroair LLC · Hilliard, OHN7573GBecker Todd J · Arlington, NEN7573MToledo Oscar · North Bergen, NJN7573QSpielman Karl K · Cortez, CON7573SHelley Mark R · Yuma, AZN7573TBogard Aviation LLC · Milan, MON7573VOlson Jerome W · Kerrville, TXN75740Kingdom Air Corps · Sutton, AKN75743Aerosmith Aviation LLC · Panama City Beach, FLN75744Blue River Aviation LLC · Palmer, AKN75746C-Squared Aviation LLC · Delaware, OHN75748Porter Steven C · White Rock, NMN75749Mckinstry Adam V · Hubbardston, MIN7574MStanphill Archie R · Lonoke, ARN7574NFloat Plane Services LLC · Saint Petersburg, FLN7574SBatavia Parag · Cranberry Township, PAN7574TWells David M · Weatherford, TXN7574VWild Angels Aviation LLC · Lascassas, TNN7574XParker Air LLC · Corinth, MSN75754Welch Gregory A · Atlanta, GAN75759Eda Of South Carolina LLC · Greenville, SCN7575GKelley Aircraft LLC · Weyers Cave, VAN7575HShepp Carl Richard Sr · Billings, MTN7575VMcbride Daryn T · Huntsville, TXN75762208 Aviation LLC · Richmond, VAN7576MFender Steven D · Baltic, OHN7576NHusum Charles · Redmond, WAN7576TInfinity Builders LLC · Parker, CON75770Griffin Robert L Jr · Washington, NCN75771Ludwig Raymond K · Scottsdale, AZN75773Dena'Ina Leasing Agency LLC · Anchorage, AKN75774Seyboth Jason R · Harvest, ALN75775Rocky Mountain Aircraft Services LLC · Broomfield, CON75776Frix Richard D · Bluffdale, UTN75778Lima-001 LLC · Muscatine, IAN7577GElkhorn Aviation Inc · Baker City, ORN7577MMorrow Scott · Sanbornton, NHN7577NAaron Aviation LLC · San Diego, CAN7577SBourbon Jeffrey A · Burns, KSN7577TRoot Franklin L · Staunton, VAN7577VPerkins Ralph Trent · Rockwall, TX
Back to AD 79-10-14 R1