AD 2002-26-01
Registered aircraft · 29,517
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:2002-26-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:2002-26-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:2002-26-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:2002-26-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.
N103SJBarnick Air Holdings LLC · Santa Barbara, CAN103SVSun Valley Aviation Inc · Harlingen, TXN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN1040JHefferon John W · Locust Grove, GAN1040UAmerican Aviation Inc · Brooksville, FLN1040ZDonnelly Jeff E · Pembroke, MAN1041CHelzer Timothy · Tucson, AZN1041HCentury Flight Systems Inc · Mineral Wells, TXN1042DCarson Roger K · Anthem, AZN1042PMcalpine David B · Fort Worth, TXN1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCN1042XN1042x LLC · Papillion, NEN1043JLanmon Herman Jr · Hamilton, TXN1043QRegistered aircraftN1043XAustin Security Corp · Battleboro, NCN1044JNagasaka Bruce J · Weiser, IDN1044LFitch Mark · Anchorage, AKN1044NMaule Flight Inc · Moultrie, GAN1045Paragon Airplane Leasing Co · Fort Myers, FLN10457Six Ten Ventures LLC · Cedar Hill, TXN1045LBernard Robert J · Millbury, MAN1045YRovers Bradley S · Chazy, NYN1046ERisk Indemnification Professionals LLC · Boston, MAN10475Lissow William M · New Port Richey, FLN1047JFirst Flight Investments LLC · Bartow, FLN1047UStueve'S Certified Organic Dairy · Oakdale, CAN1048DDumbravo Dustin C · Yorktown, VAN1048LSparrow Thomas E · Hawley, MNN1049JLoxley Jason C · Virginia, ILN1049TRoberts Kevin C · Athens, GAN1049XValleyside Farm LLC · Woodstock, CTFirst renewal noticeN104AAMeridian Aircraft LLC · Wilmington, DEN104ABPeterson Kevin D · Peoria, AZN104ALDinardi Allen J · Jacksonville, ORN104AZJarrell Rodney M · Phoenix, AZN104BABemidji Aviation Services Inc · Bemidji, MNN104BCHoudek Todd L · Roseburg, ORN104BKCharlie Alpha Bravo LLC · Spring Hill, KSN104BRBelsaas Richard A · Rapid City, SDN104CDOlson Timothy D · Elk Mound, WIN104CPN7293l LLC · Waxahachie, TXN104DFHayton Thomas M · Arcadia, OKN104DHPiper Aircraft Inc · Vero Beach, FLN104DPMajul Enterprises Inc · Saint Petersburg, FLN104EHaas Bruce F · Lynden, WAN104EDEdwards Aero Club · Edwards Afb, CAN104EEWestfall Benjamin C · Coeur D Alene, IDN104EPEarwood Edward A · Sonora, TXN104EREmbry Riddle Aeronautical University · Daytona Beach, FL
Back to AD 2002-26-01