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.
N756MYRegistered aircraftN756MZSchreck Lynn G · Elk City, OKN756NDRegistered aircraftN756NGPerrigue Thomas E · Bishop, TXN756PFTaiga Mining Co Inc · Anchorage, AKN756PKBuoy Michael · Magnolia, TXN756PYAssociated Pilots Inc · Concord, MAN756QGKetchum Craig L · Anchorage, AKN756QPKako Retreat Center Inc · Russian Mission, AKN756QVAms Aviation LLC · South Bend, INN756RSMiddle Fork Aviation Inc · Challis, IDN756SGWaters Aero Marine Inc · South Thomaston, MEFirst renewal noticeN756SLCecs LLC · Lakewood, NYN756SPCrest Airpark · Kent, WAN756UJMydive Aviation LLC · Denver, CON756UKAircraft Guaranty Corp Trustee · Oklahoma City, OKN756UWTrue North Air LLC · Anchorage, AKN756VCDavis Michelle R · Port Alsworth, AKN756WGRood Charles · Vancouver, WAN756WJBritt Westley · New Paltz, NYN756WRReinbold Frederick K · Anchorage, AKN756XEKachemak Air Service LLC · Homer, AKN756XYArizona Air Salvage · Phoenix, AZN756YCMb Aviation LLC · Ridgefield, WAN756YDGarza Aircraft Inc · Harlingen, TXN756YHGroundhog Mining And Milling Co LLC · Dillon, MTN756YSShoreline Consulting · Bryan, TXN756ZHHeartland Aviation Inc · Alliance, NEN756ZVSmokey Bay Air Inc · Homer, AKN757United States Department Of Interior · Boise, IDN75701Roseville Aviation LLC · Roxboro, NCN75704Lanning 1 Aviation LLC · Amarillo, TXN75706Morey Airplane Company Inc · Middleton, WIN75709Newsom Richard W · East Bend, NCN7570MBarreto Brian C · Lebanon, ORFirst renewal noticeN7570NHoussiere Daniel D · Arcadia, CAN7570SBurns Stephen M · Newport, ORN7570XJones Frank E · Merritt Island, FLN75710Cox Leon F · Ruffin, NCN75711Falcon Air LLC · Anchorage, AKN75712Hill David Ryan · Palm City, FLN75714Lincoln Skyways Inc · Lincoln, CAN75716West Bend Air Inc · West Bend, WIN7571EHaack John L Trustee · Dunedin, FLN7571GCook Thomas B · Boston, MAN7571NCasteneda Jose · Yakima, WAN7571SBeyond The Clouds LLC · Elkhorn, NEN7571VRothstein Tim P · Litchfield, MNN7571XBrown Bomber Aviation LLC · Little Rock, ARN75721Propell Air LLC · Deridder, LA
Back to AD 79-10-14 R1