AD 95-26-13
Registered aircraft · 21,464
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:95-26-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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.
N1243HGordon Stephen · Warrington, PAN1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingN124JCDestination Aviation LLC · Destin, FLN124JDBailes Christopher · Orlando, FLN124MTMiddle Tennessee State University · Murfreesboro, TNN1250TStanley Natasha S · Lorton, VAN1250UPiper Aircraft Inc · Vero Beach, FLN1251TMcvey Cindy M · Colts Neck, NJN1253TDellemonoche Dennis R · Tabernacle, NJN1254TStewart Doug A · Indianola, NEN125LSchlamer Mark A · Campbellsport, WIN125MTMcdonald Theresa C · Beaufort, SCN125VSMcfarland Joel E · Pittsford, NYN1260TRed Rock Flying School LLC · Mesa, AZN1261TObrien Timothy D · Alplaus, NYN1264THolloway Andrew F · Woodville, TXN1268TFortney Thomas Kent · Humble, TXN126LMMatt Aviation Propertis Inc · Nashua, NHN126PCRoots & Wings Aviation LLC · West Simsbury, CTN126PKPtk Equipment Inc · Miami Lakes, FLN1270TTubman Wilbur C · Grand Rapids, MIN1272TMyers Brent A · Palm Bay, FLN1273TZulu Aviation LLC · Newcastle, OKN12757Altitude Aviation Group LLC · Christmas, FLN1276TShillieto Mark C · Wilmington, OHN1278TSmith Sullivan · Cookeville, TNN127AVPlane Fun Inc Tr Trustee · Snellville, GAN127GT7 Golf Tango LLC · Saint Petersburg, FLN127MDCosbie Lee R · Tuscumbia, ALN127MTPilotsplane LLC · Boca Raton, FLN127VGEvans James F · Columbus, GAN1280TCertified Equipment Inspections LLC · Washington, PAN1284NAbnc Air LLC · Wellington, FLN1284WBethel Don G · Bossier City, LAN1286GRegistered aircraftN1286THeffelfinger Paul D · Seven Valleys, PAN1287TBelle Casa Aero LLC · Tarpon Springs, FLN1288HFly By Knight Inc · Hammond, LAN128AGarza Family LLC · Helena, MTN128DPGherebi Belaid A · San Diego, CAN128GRJaques Stanley S · Cassville, MON128HBSowle LLC · Tampa, FLN128WPPatterson Weldon E · Maryville, TNN1290HWeiss Gregory K · Manitou Springs, CON1295TLutz Brian · Carmel, INN1297HHop A Chopper Inc · Dover, DEN1297TReich David W · Fort Lauderdale, FLN129EWSky West Aviation Inc Trustee · Albuquerque, NMN129MAAttwood Nicholas John · Ashburn, VAN129SAUnlimited Vertical LLC · Milton Freewater, OR
Back to AD 95-26-13