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.
N129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN12ERPropelling The Gospel Missions Inc · Standish, MEN12FMDelaware State University · Dover, DEN12HFParagon Airplane Leasing Co · Fort Myers, FLN12STWise Ventures LLC · Mooresville, NCN12TCCb22 Holdings LLC · Price, UTN1301UDonohue Thomas · Carmel, NYN1307HDileo Steven · Gallatin, TNN130BWPobiega Michael J · Fort Mill, SCN130DGDixie Aviation LLC · Pelham, ALN130GHBose Tamal · Tucson, AZN130JMRegistration Pending · Tampa, FLRegistration pendingN130KSouthern Aircraft Consultancy Inc Trustee · NorfolkRegistration ineffective or invalidN130RRAllbritten Jeffrey P · Winder, GAN130TLynch Machining LLC · North Vernon, INN130XRM&A Adams Family Lp · Mckinney, TXN1310KVector Aviation LLC · Mentor, OHN1310UPiper Aircraft Inc · Vero Beach, FLN1317HLightfoot Carl · Beaumont, TXN1317TWhite Tavon L · Stockbridge, GAN1318TAire-Drifter LLC · Staten Island, NYN131CACoast Flight Training And Management Inc · San Diego, CAN131LLAims Community College · Greeley, CON131LRCharles City Aeronautics Inc · Charles City, IAN131PAAmeriflyers Of Texas Inc · Addison, TXN131RJEggleston William A · Wayland, MAN1321HKronick Brad S · Grand Prairie, TXN1326TNelson Raul · Annapolis, MDN1327TCedel Solutions LLC · Austin, TXN132AMTemple James C · Lincoln, CAN132BCUniversidad Interamericana De Puerto Rico · Bayamon, PRN132CACoast Flight Training And Management Inc · San Diego, CAN132CHSimon Aviation LLC · Bourg, LAN132DRAasap Construction Co Inc · Conway, SCN132GMSky West Aviation Inc Trustee · Albuquerque, NMN132GTLegal Eagle 2 LLC · Jefferson City, MON132KMKing General Contractors Inc · Bristol, VAN132LESouthern Aircraft Consultancy Inc Trustee · Casper, WYN1330TPremium Air LLC · Bloomfield, MIN1331LFirst Response Anesthesia Inc · Washington, UTN1331TValdez Freddy · Fontana, CAN1332TSchwartz Matthew M · Royal Oak, MIFirst renewal noticeN1333HN1333h LLC · Brooklyn, NYN1334TCrt Aviation LLC · Clarkston, MIN1335HLmm Solutions LLC · Coppell, TXN1337TTrate Ava · Selbyville, DEN133CBBrown Milton S III · Raleigh, NCN133PTKittle David · Siloam Springs, ARN133SFNelson Dennis E · Jamestown, NDN1340TMaw Enterprises USA LLC · Hudson, FL
Back to AD 95-26-13