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.
N7116QStogner Sarah E · Monahans, TXN7116TMaierhoffer Henry F · Sylvania, GAN7116XWeggel Roger · Fairbanks, AKN71178Four Forces Of Flight LLC · Orlando, FLN7117GBaker Brady B · South Hero, VTN7117MFly 2 Hope LLC · Hilliard, FLN7117TOrtega Rolando J · Davie, FLN7117XBoldog Sandor Alex · Andalusia, ALN71187Watermeier Daniel W · Syracuse, NEN71188Youderian Kenneth E · Coupeville, WAN7118GRegistration Pending · Spruce Pine, ALRegistration pendingN7118QMartin Stephen T · Green Cove Springs, FLN7118SSanders John B DBA · Knoxville, TNN7118XRosier Wayne C · Lexington, NCN71198Bretschneider Danny · Wichita Falls, TXN7119AMcfarland Michael G · Seabeck, WAN7119ENary Jeffrey C · Bend, ORN7119FCossette Bradley J · Detroit Lakes, MNN7119MSutton Aircraft Salvage LLC · Palmer, AKN711ACLandry Michael J · Elkin, NCN711AKCroft Rick D · Alva, OKN711DCDufford Michael W · Alpine, CAN711DRAntique Aircraft And Automobile LLC · Van Alstyne, TXN711FBLing Scott P · Old Saybrook, CTN711FHAntler Air LLC · Klamath Falls, ORN711GTRadcliff Charles · Las Vegas, NVN711GWZwar Jeffrey · Methow, WAN711JFTwin D LLC · Lake City, FLN711JMCarro Del Cielo LLC · Santa Paula, CAN711JSSterling Flight Training · Jacksonville, FLN711KCN711kc Fliers LLC · Oak Park, CAN711KFJ-Com Aviation LLC · Richland, MSN711MRBrown Jason L · Happy Valley, ORN711NFSkywarrior Flight Training Inc · Pensacola, FLN711NGHummingbird Air Service · Lincoln, NEN711PJRender Chad · Pine Bluff, ARN711PLFreedom Skies Aviation LLC · Oakland, MIN711RMMoore Roger · Louisville, KYN711RNGoldsmith Donald E Jr · Brandywine, MDN711SNSkywatch Aviation LLC · French Village, MON711TGRegistration Pending · Lakeville, MNRegistration pendingN711TMPeters James L Trustee · Brighton, MIN711TWMartens Ruth C · Wheaton, ILN711UATuthill Andrew M · Etna, NHN711WEMelbourne Flight Training LLC · Melbourne, FLN711WFSmith Lot P · Grangeville, IDN711XPArsenie Michael D · Roxbury, CTN711ZHappenstance LLC · Cabot, ARN711ZGHutton Mark B · Denison, TXN71202Anderson Kyle J · Hales Corners, WI
Back to AD 79-10-14 R1