AD 80-25-07 R1
Registered aircraft · 25,368
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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.
N8999GSouther Field Aviation Inc · Americus, GAFirst renewal noticeN89GKCasa Jets Inc · Pittsford, NYN89KAKenmore Air Harbor LLC · Kenmore, WAN89KPRegistered aircraftN89LWClose Bert W · Peachtree City, GAN89MMSic Sac Fliers LLC · Gainesville, FLN89SFMiller Luke · Redmond, WAN89TWAlpine Aerobatics LLC · Chelsea, MAN89WSStevenson Wayne · Georgetown, MNN8CCMag 3 Aviation LLC · Vidor, TXN8CKPresley Danny K · Homer, AKN8DBBaker Drew A · Little Rock, ARN8DLKnowlton James W · Au Gres, MIN8ETAshby Dennis A · Paris, TXN8FYMacauley Edwin T · White City, ORN8HLEvans Jack E · Carlisle, ARN8KLWiebe Joerg · Sarasota, FLN8KRQualitair LLC Trustee · MichelstadtN8PMChristmas Michael G · Long Beach, CAN8QCKaiser Paul A · Juneau, AKN8RRCarey Patrick T · Hawthorne, CAN8SFScarbrough Christopher R · Palestine, TXN8TRAviation Academy LLC · Wichita, KSN8UKIvey Thomas S · Gladewater, TXN8YAInternational Air Services Inc Trustee · Carson City, NVN8YQHartlieb Gordon Wesley · Anchorage, AKN8ZXKansas Farm And Ranch Inc · Seneca, KSN9000LHuff Ryan P · Oak Harbor, WAN9002EWisconsin Aviation Inc · Watertown, WIN9002HAngel Aviation Inc · Peoria, AZN9002NJohnson Lawrence F · Anchorage, AKN9003EBermuda Dunes Flight Training LLC · Palm Desert, CAN9004LThoman Mark C · Jacksonville, NCN90052Laz Stanley R · Snohomish, WAN9005HBuffalo Aviation LLC · Royal, NEN9005LColorado Twin Bonanza LLC · Broomfield, CON90076Tilts Brandon J · Flagstaff, AZN9007RWill Michael · Mukilteo, WAN9008LP And C Flying Club LLC · Williamsport, PAN9009HConnell Flying Service Inc · Decorah, IAN9009LSale Reported · Fairbanks, AKSale reported, pending cancellationN900AGFriedman & Friedman Ltd · Chicago, ILN900RKTailwind Tales LLC · Chesapeake, VAN900TXWilliams Harry · Summerland Key, FLN9011LLussier John A · Greene, RIN9012HLeading Edge Flight Academy LLC · Bend, ORN9013LBarbee Lisa · Dallas, TXN9014HFlex Air Holdings Inc · Manhattan, KSN9015LMalone Aaron E · Wasilla, AKN9017HMeece Harvey T · Somerset, KY
Back to AD 80-25-07 R1