AD 76-15-08
Registered aircraft · 2,268
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:76-15-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-15-08')
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:76-15-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-15-08') 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.
N113TRBell Thomas E · Henniker, NHN113WYRyals Barry · Rhine, GAN1147HSpacious Skies LLC · Overland Park, KSN1147XPax Flyers LLC · Hollywood, MDN115DCLong Jerry D · Solvang, CAN1160XWagner Robert J · Dubuque, IAN1164XRegistered aircraftN1177AN1177a LLC · Lewes, DEN1179XDesch Edward J III · Aldie, VAN117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CAN1188XSteven H Baker Construction Co · Big Bear City, CAN118ESCmv Aviation LLC · Johnson City, NYN1198HAlge Aviation · Middletown, DEN11FLBell Christopher K · Ashley, OHN11JUPottorff Gregory K · Wayne City, ILN120CDJackson Farms Callahan Division LLC · Callahan, FLN1216TOlsen Christopher D · Bothell, WAN1217TSauer Roger A · Glenburn, NDN121DBTexins Flying Club · Mckinney, TXN121GHSunset Aviation LLC · Huntington, INN121TWBlue Ridge Mountain Flyers Aviation LLC · Mineral Bluff, GAN1222TPraniewicz Charles P · New Kensington, PAN1227TStieper David Paul · Forest Lake, MNN12354Spencer Christopher · Voorheesville, NYN1236TOtero Edgardo A · Tucson, AZN123KCHelms Brandon M · Indian Trail, NCN1253TDellemonoche Dennis R · Tabernacle, NJN1254TStewart Doug A · Indianola, NEN1272TMyers Brent A · Palm Bay, FLN1280TCertified Equipment Inspections LLC · Washington, PAN1284WBethel Don G · Bossier City, LAN128GRJaques Stanley S · Cassville, MON129EWSky West Aviation Inc Trustee · Albuquerque, NMN130DGDixie Aviation LLC · Pelham, ALN1321HKronick Brad S · Grand Prairie, TXN1333HN1333h LLC · Brooklyn, NYN1334TCrt Aviation LLC · Clarkston, MIN133CBBrown Milton S III · Raleigh, NCN1341TShuman Cecil R Trustee · Chugiak, AKN1342TCrewdawg Aviation LLC · Concord, NCN1349TMjl Flyers LLC · Somerset, PAN134JSSparling Albert E · Hubbard Lake, MIN1354TRiverside Flight Academy Inc · Riverside, CAN1360TDibrino Ruth G · Hillsboro, ORN1367TN1367t LLC · Mount Dora, FLN1385TRayfield Charles · Downingtown, PAN1395TLegacy Aerospace Industries LLC · Miami, FLN1399TLauff Samuel Jr · Ocala, FLN139DMMurillo Raymond A · Pico Rivera, CAN1406TCitabria Inc · Auburn, CA
Back to AD 76-15-08