AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N7070DDestaffany Elizabeth L · Los Angeles, CAN7070EKuchn Todd S · Wabasso, MNN7070FDaub David M · Sealy, TXN7071AFieldman Gregory S · Olympia, WAN7071BFreelance Outdoor Adventures LLC · Eagle River, AKN7071EPlumstead Lawrence P · Seminole, FLN7071FPadgett Troy A · Midway, TXN70729Fleury Guzman Andres R · Clinton, NCN7072ABig R Of Greeley · Greeley, CON7072FMiller Richard M · New Galilee, PAN7072JMax Cl Inc · Wilmington, DEN7072MWhisler Jon N · Shady Shores, TXN7072SEstby Hans P · Hayfield, MNN7072TFlaugher P Diane · Beloit, WIN7073EWestrum Durl T · Norwalk, IAN7073FBushby David R · Barnesville, GAN7074AFogg Morgan T · Pierce, CON7074SBoening Bros Dust & Spray Svc · Floresville, TXN7074TNielson Dean A · Inchelium, WAN7075AStonebrink Arnold · Payson, AZN7075FGillette Timothy R · Ipswich, MAN7075MPs Aviation Inc · Granada, MNN7076SHaeg Timothy R · Saint Joseph, MNN7076TLuebke Harold W Jr · Stuttgart, ARN70777Skywagon Aero LLC · Wilmington, DEN7079ADerbe LLC · Durham, NCN707JYBest Glide LLC · Davie, FLN707MTams LLC · North Las Vegas, NVN707REHamm Mark W · Eagle River, AKN707WMSnake Bit Aviation LLC · Pelham, GAN7080ARedmon Michael P · Canal Winchester, OHN7080EHamdan Isam · Tulsa, OKN7080MMelvin Scott W · Cookson, OKN7080TKingdom Planes LLC · Decatur, TXN70817Pope Michael P · Chippewa Falls, WIN7081ASeibert Edwin M · Swansea, SCN7081EMedley Matthew C · Shelbyville, INN7081FHayes Travis · Harrisonville, MON7081SGustafson Clayton H · Woodbury, CTN7081TYanez Manuel R · Calexico, CAN70824Heidebrink James M · Bloomington, ILN7082BOleck Ross R · Wasilla, AKN7082FBuchanan Walter C · Yuma, AZN7082TGarrett Kasey L · Wilder, IDN7084ABaldwin Glen R · Culdesac, IDN7084EKnight Darrell K · Temple, TXN7084SGreer John M Jr · Mercer Island, WAN7084THeitkamp Douglas C · Barney, NDN7084XPatry Aeronautical Institute · Kalispell, MTN70851Blue Mountain Aviation LLC · Sioux Falls, SD
Back to AD 94-05-05 R1