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.
N5156AFrantz Douglas M · Mustang, OKN5156ESchwankl Michael James · Wasilla, AKN5156JWings Over La Aviation LLC · West Hills, CAN5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN5156RKookaburra Kiwi LLC · Post Falls, IDN5156YCaprock Spraying Inc · Vega, TXN5157DPari Gabe M · Ontario, CAN5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN5157NAms Aviation LLC · South Bend, INN5157VHarwig Robert P · Longville, MNN5157ZAspire Aviation LLC · Farmingdale, NYN51580Middletown Regional Flight Training Institute LLC · Middletown, OHN51582Flight School Of Gwinnett Inc · Lawrenceville, GAFirst renewal noticeN5158EHuettl Austin · Liberty Hill, TXN5158JTfs Air LLC · Loveland, CON5158QAnglin Cheryl · Jackson, MSN5158RBrandenburg Idu LLC · Brenham, TXN51590Kadena Aero Club · Apo, APN51594Candace A Larned Enterprises Inc · Long Beach, CAN5159ADavis Nicholas R · Madera, CAN5159DFleming James Daniel · Kansas City, MON5159NO Bleness Kevin W · Bethel, AKN5159RBackcountry Adventures LLC · Big Lake, AKN5159UPostolnikov Paul V · Graham, WAN515CLProfessional Pilot Services LLC · Miami, FLN515EDBlue Sky Pilots Inc · Salem, ORN515HE2f Trade LLC · Gainesville, TXN515KPKading Air LLC · Urbandale, IAN515LXJones Johnny V · Crab Orchard, KYN515MAAdams Scott M · Seabrook, TXN515MBMoxie Air LLC · Winston Salem, NCN515NAikens Susan R · Delta Junction, AKN515RDWings Over Texas Holdings LLC · Denton, TXN515RTCemco Industrial Park LLC · Belen, NMN515RVFlying Adventures Tm LLC · Talkeetna, AKN515SPFriedlander Ernest · San Francisco, CAN51608Commonwealth Of Kentucky · Frankfort, KYN5160ABowden Aaron C · Yuma, AZN5160DPatton Jay A · Hobbs, NMN5160ELeading Edge Flight Academy LLC · Bend, ORN5160RTownley Wren Adam T · Orwell, VTN51614Stillwater Flyers LLC · Columbus, MTN51616Stardust Aviation LLC · Farmingdale, NYN5161ASchmid Robert E · Red Bluff, CAN5161DKnutson Wayne R · Thompson, NDN5161NLewis Justin R · Frederick, OKN5161USkyler Aviation · San Diego, CAN5162ASizer Timothy J · Arthur, NEN5162DRodrigues George C · Aiken, SCN5162FLosasso Michaela Marie · Scottsdale, AZ
Back to AD 79-10-14 R1