AD 80-26-04 R1
Registered aircraft · 1,267
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-26-04-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-26-04-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-26-04-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-26-04-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.
N5911YDileo Steven J · Gallatin, TNN5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSN5922YUltimate Air Parts LLC · Strasburg, VAN5930YHopkins Frank Michael · Wilmington, DEN5938YFly For Fun Aircraft LLC · Rockville, MDN5948YFbm LLC · Laporte, INN5955MMonte'S Flying Circus LLC · Wonder Lake, ILN5961YWillis Burlin T · Wasilla, AKN5963YS And S Aviation Consulting · Hampshire, ILN5972YBm Aviation LLC · Vinton, VAN5977YRed State LLC · Daytona Beach, FLN5982YDawkins Karlene A · Coral Springs, FLN5986YBlackhawk Holding Corp · Wilmington, DEN59EEKern Raymond L · Bedford, INN5HMEvans Hayward D · Saint Augustine, FLN6000PMoseley Timothy D · Calhoun, KYN600RJRankin Richard · Germantown, TNN6011YTab Associates Inc DBA · Port Saint Lucie, FLN6017YTulsa Technology Center School District No 18 · Tulsa, OKN6030YReddick Brent · Paragould, ARN6034YTan American Corporation · New York, NYRegistration revokedN6039YAllen Aviation Inc · Aynor, SCN6044YPinnock Charles W · Port St Lucie, FLN6046YWells Douglas A · Chino, CAN6052YCentral Kentucky Aviation Inc · Bardstown, KYN6058YEltgroth Peter G · Livermore, CAN6062YJahba LLC · Coral Springs, FLN6069YAngelman Aviation LLC · Prosper, TXN606CACv Wings LLC · Canby, MNN6085YPharmair LLC · Jackson, MSN6089YAerosavant LLC · Towanda, PAN6092YClean Waste Solutions LLC · Indianapolis, INN60LFNorthwoods Air LLC · Orono, MEN60MBCurry Arnold J · Houston, TXN611SGRph Engineering LLC · Lehi, UTN611WWCone S E Jr · Hobbs, NMN6121YWeaver Scott Allen · North Logan, UTN6125YDelaware Aircraft Trust LLC Trustee · New Castle, DEN612EHIsland Flyers Inc · Addison, TXN612MRFladr LLC · Westfield, NJN612WWEhecatl LLC · Fort Wayne, INN613RAKampa Arnold J · Vero Beach, FLN613WKKnaust Jerry L · Blue Jay, CAN6140YSouthern Seaplane Inc · Belle Chasse, LAN6149YRobbins Warren N · Chandler, AZN6164YStriplin James R Jr · Hartford, ALN6169YWiesen Enterprises Ltd · Empire, MIN6170YGe Org Advanced Systems LLC · Newton, NJN6180YChilton Leonard Jay · Caddo Mills, TXN6189YSmith Brian Charles Jr · Lake Mary, FL
Back to AD 80-26-04 R1