AD 49-48-01
Registered aircraft · 425
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:49-48-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:49-48-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:49-48-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:49-48-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.
N2897DMiller Earl R · Gig Harbor, WAN2897VSky West Aviation Inc Trustee · Albuquerque, NMN2899VMtv Aero Group · Pauls Valley, OKN2923CColley Robert E · Jamestown, TNN2927VHereth Eric W · El Cajon, CAN2929VEllis Donald D W · High Springs, FLN2975VBuckalew James E · Kingsville, TXN2976VDolby Kevin L · El Paso, TXFirst renewal noticeN2979VZxtair LLC · Mankato, MNN2983VBellgardt Robert · North Bend, WAN2987BKrog Donald C · Somerville, NJN2989VContessa Holdings Ltd · Cheyenne, WYN2991VParsons Franklin R Jr Trustee · Kiowa, CON2992VSheridan Jeffrey S · Lakeville, MNN2994VJetmx Inc · Goodyear, AZN2997VMcmahon Jeffrey J · Paris, KYFirst renewal noticeN2TDRds LLC · Strongsville, OHN3001VHillier David C · Oakdale, CAN3013VCusick Christopher J · La Jolla, CAN3019VTimmons Mark M · New Port Richey, FLN3021VMunoz Pedro L · Ontario, NYN3041VGood Brian L · Wildomar, CAN3056VMinneman Alan R · Jefferson, TXN3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationN3064VLehmann Mark C · Trade, TNN3065VEvans Bruce E · Aztec, NMN3068VBurgin Lee · Borger, TXN3074VHancock Steven W M · Bristow, VAN3083VAnderson Charles E · Fort Worth, TXN3088VStartz John D · Dallas, TXN3089VMaximus Aviation LLC · Cheyenne, WYN3093VBeavers Charles M · Rockmart, GAN3096VNovak Warren Devereaux Grey · Lake Placid, FLN3101VWallace William D · Brunswick, GAN3111VStewart Ladd E · Augusta, KSN3114VWheeler Jack W · Greensboro, NCN3119VMartin Lynn E · Princeton, TXN3127VTyner Steven P Trustee · Lees Summit, MON3140VLayton Matthew K · Mesa, AZN3145VClonts Dale · Safford, AZN3146VWittmeyer Jamie J · Wyomissing, PAN3147VRobb Steven G · Riverside, CAN3150VSanders John B · Knoxville, TNN3159VHoogestraatcarl W · Bangor, PAN3164VDisdier David C · Vinita, OKN3171VCarpenter Colt A · John Day, ORN3173VLae Media Group LLC · Gardner, KSN3178VHowell Larry A · Terrell, TXN3181VSitkins Amber A · Ozark, MON3190VTop Flight LLC · Wilmington, DE
Back to AD 49-48-01