AD 2002-17-53
Registered aircraft · 6,266
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-17-53')
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-17-53')
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-17-53') 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-17-53') 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.
N1285ROrbit Aviation LLC · Lakewood, CAN1287TBelle Casa Aero LLC · Tarpon Springs, FLN128AGarza Family LLC · Helena, MTN128EDSimply Living LLC · Fort Myers, FLN128HBSowle LLC · Tampa, FLN128MGHastings Gladstone E · Miramar, FLN128WPPatterson Weldon E · Maryville, TNN1297TReich David W · Fort Lauderdale, FLN129BBLawson Michael · Englewood, TNN129MBYellowfin Air Services LLC · Wilmington, DEN129RCAirris Aviation & Marine Co · N Fort Myers, FLN12BHMunk-Ee Business Aviation LLC · Linden, MIN12GEJ&P Master Flooring Corp · Lauderdale Lakes, FLN12KWAllied Moulded Products Inc · Bryan, OHN12LVR2b2 Enterprises Lllp · Weldon Spring, MON12STWise Ventures LLC · Mooresville, NCN12TZJ H O Enterprises Inc · Carol Stream, ILN12WZNortech Data Services Inc · Wilmington, DEN12XLAurora Aviation LLC · Billings, MTN130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKN130XRM&A Adams Family Lp · Mckinney, TXN1315BN1315b Aviation LLC · Wilmington, DEN131DLEscondido Aviation LLC · Marfa, TXN131FAJones Donald T Jr · Barrigada, GUN131PJCrosswinds Flight Center Inc · Drums, PAN131RLLeads Air Inc · Dover, DEN131TPremiere Aircraft LLC · Dover, DEN131TVO'Brien Daniel H · Half Moon Bay, CAN1322YAlcyone Trust Corp Trustee · Wichita, KSN1322ZInternational Realty Group LLC · Bakersfield, CAN1323NJohnston Jeffrey Heath · Midland, TXN13259Nuthatch Air Services LLC · New York, NYN1325DMontero Carlos · San Lorenzo, CAN1325YDuty First Holdings LLC · Wichita, KSN1327TCedel Solutions LLC · Austin, TXN1328NFirst Agri Inc · Sudan, TXN1329DHewitson Enterprises Inc · Avenal, CAN132CHSimon Aviation LLC · Bourg, LAN132DRAasap Construction Co Inc · Conway, SCN132GMSky West Aviation Inc Trustee · Albuquerque, NMN132GTLegal Eagle 2 LLC · Jefferson City, MON132LTCobblestone Capital Aviation LLC · Sylacauga, ALN133CTValiair Lc Trustee · Casper, WYN133DR814ma Inc · Van Alstyne, TXN133KBIsland Time Aviation LLC · Peachtree City, GAN133PRJamian Corporation · Lewes, DEN133WCRegistration Pending · Huntingdon, TNRegistration pendingN1343TWestern Cherokee Six LLC · Fort Collins, CON134CHTeke Elevate LLC · San Antonio, TXN134GWFord Matthew L · Clayton, GA
Back to AD 2002-17-53