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.
N11132Triple One 32 LLC · Sergeant Bluff, IAN1113ULeft Base Aviation LLC · Niagara, WIN1117XHarshman James M · Washington, PAN1118QAscend Aviation LLC · Bountiful, UTN1118XKdr Avgroup LLC · Wilmington, DEN1118ZMoorhouse Mark A · Santa Fe, TNN111AEMatthews Timothy I · Belvidere, NJN111AJBergin Donald M · Ormond Beach, FLN111AZ360 LLC · Carson City, NVFirst renewal noticeN111CPVelasco Ricardo Rene Jr · Cumming, GAN111DJLee Brian A · Riverdale, GAN111EMMccue Inc · Florence, MTN111FBMccarthy Elaine M · Indianapolis, INN111FCWoody Air LLC · Vero Beach, FLN111FPPhoenix Carolina LLC · Saint Petersburg, FLN111FRAirward Inc · Novato, CAN111LUSchaefer Robert Lee · Orange, CAN111MBTinder John A · Rancho Cucamonga, CAN111NPBlackfoot Aviation LLC · Bozeman, MTN111NWKnell LLC · Casper, WYN111RWNordo LLC · Kettering, OHN111SNHalbert Kevin · Tyler, TXN111WMMoore Forrest · Liberty Hill, TXN1121XCrosscheck Ftc LLC · Greeneville, TNN1122ACox Abraham · Key West, FLN1122EVasey Igor · San Francisco, CAN1123WThiel Jonathan Ronald · Billings, MTN1125TSpruce Tiger Aviation LLC · Dallas, TXN1125XApm Leasing LLC · Casper, WYN1126HHead Lewis T · Portland, TNN1126QGibbs Robbie Douglas · Lacombe, LAN1126XBolobonoff Alexander G · Kingman, AZN1128QZastrow Andrew S · Knoxville, TNN112JMGuzman John · China Spring, TXN112JRValleau Matthew J · Wallingford, CTN112LGAb Prop Plane I LLC · Metairie, LAN112TPHarper Gary B · Fitzgerald, GAN112WMInternational Air Services Inc Trustee · Carson City, NVN1132QWattum Investments LLC · Kodiak, AKN1134QFalyers Inc · Prairie Du Chien, WIN1138FSky West Aviation Inc Trustee · Albuquerque, NMN1138XPierce Nathaniel Antonio · Magnolia, DEN1139LMathewson Crews Aviation LLC · Indianapolis, INN113EJIxi LLC · West Bloomfield, MIN113GAtp Aircraft 9 LLC · Wilmington, DEN113HMAkins Tal M · Register, GAN113JCMcdonnell Bryant E · Boulder, CON113KRIal Corp · Lewes, DEN113SWFargo Jet Center LLC · Fargo, NDN113TRBell Thomas E · Henniker, NH
Back to AD 95-26-13