AD 80-19-01
Registered aircraft · 2,288
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-19-01')
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-19-01')
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-19-01') 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-19-01') 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.
N1188XSteven H Baker Construction Co · Big Bear City, CAN11CWJabez Aviation LLC · Petaluma, CAN11FLBell 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, TXN1222TPraniewicz Charles P · New Kensington, PAN1227TStieper David Paul · Forest Lake, MNN122MCShouk Aviation LLC · Waverly, OHN12354Spencer Christopher · Voorheesville, NYN1236TOtero Edgardo A · Tucson, AZN124MTMiddle Tennessee State University · Murfreesboro, TNN1253TDellemonoche Dennis R · Tabernacle, NJN1254TStewart Doug A · Indianola, NEN125MTMcdonald Theresa C · Beaufort, SCN1272TMyers Brent A · Palm Bay, FLN127MTPilotsplane LLC · Boca Raton, FLN1280TCertified Equipment Inspections LLC · Washington, PAN1284WBethel Don G · Bossier City, LAN128GRJaques Stanley S · Cassville, MON129EWSky West Aviation Inc Trustee · Albuquerque, NMN129SAUnlimited Vertical LLC · Milton Freewater, ORN130DGDixie Aviation LLC · Pelham, ALN130TLynch Machining LLC · North Vernon, INN1334TCrt 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, FLN137CCMore Right Rudder LLC · Sioux City, IAN1385TRayfield Charles · Downingtown, PAN1386TGeorgia Aviation Authority · Eastman, GAN1395TLegacy Aerospace Industries LLC · Miami, FLN1399TLauff Samuel Jr · Ocala, FLN139DMMurillo Raymond A · Pico Rivera, CAN1406TCitabria Inc · Auburn, CAN1410TWelch Bruce E · Boyce, VAN1411TCable Marsha A · Toronto, OHN1412HAsherbranner Charles E · Yucaipa, CAN1418XHaskin Kent B · Claverack, NYN1419TBrolan Aviation LLC · Kansas City, MON1425TSkydance Aviation LLC · Norfolk, VAN1429XRegistered aircraftN142MHAerospace Trust Management LLC Trustee · Wilmington, DE
Back to AD 80-19-01