AD 2002-01-10
Registered aircraft · 816
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-01-10')
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-01-10')
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-01-10') 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-01-10') 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.
N31WPSale Reported · Gaylord, MISale reported, pending cancellationN3216KSouth River Services LLC · Myrtle Beach, SCN321DZNardi Greg · Missoula, MTN3220LPee Dee Aviation LLC · Florence, SCN3221MGuardian Flight LLC · Lewisville, TXN322MRPf Aircraft LLC · Graham, TXN322RN322r LLC · St Simons Island, GAN323HADale Aviation Inc · Rapid City, SDN3246SInsync Investments LLC · Dover, DEN325RRCentral Virginia Aviation Inc · North Dinwiddie, VAN3262REaglemed LLC · Wichita, KSN3263CEaglemed LLC · Wichita, KSN3263NGuardian Flight LLC · Lewisville, TXN329GSAugusta Aviation Inc · Hilton Head Island, SCN32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PAN32PDynamic Avlease Inc · Bridgewater, VAN32RHPor Aviation LLC · Huntersville, NCN330DBBlueskyways LLC · Bend, ORN330VAlcovy Mountain Venture LLC · Monroe, GAN332DEMetro Aircraft Co · Bloomington, MNN332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCN333TLBrad And Jill Janecke LLC · Pierre, SDN333XPRichard L Richards Pa Trustee · Coral Gables, FLN339KAChenango Aviation LLC · Dallas, TXN33FRCharles L Fridge III Pc · Houston, TXN33SBPittsburgh Institute Of Aeronautics · West Mifflin, PAN342ERSoutheast Aviation LLC · Oxford, MSN34CEFirst Call Home Health Agency LLC · Salem, ORN34HAHarper Aerospace LLC · Murfreesboro, TNN34MFDavis Aviation Inc · Brandon, MSN351GRDodson International Parts Inc · Rantoul, KSN354AVAev Aviation LLC · Hilton Head Island, SCN355PCEagles Wings Avaition LLC · Monroeville, ALN35BAC90 Air Inc · Lemoore, CAN35CVNavajo Enterprises LLC · Schwenksville, PAN35HDGuardian Flight LLC · Lewisville, TXN35TVN35tv LLC · Shawnee, OKN362MCAircraft Guaranty Corp Trustee · Oklahoma City, OKN366GWK&K Leasing Inc · Tea, SDN3690FWv Gastro & Endo LLC · Wheeling, WVN3695WSuarez-Ballardo Jorge Luis · Glendale, AZN369RSEarly Bird Air LLC · Lawrence, MIN369WTSterling John · Port Lavaca, TXN36TGRv Holding LLC · Winchester, MAN3700MBoeing Co · Berkeley, MON370UBoard Of Regents Of The University Of Oklahoma · Norman, OKN377PUig Transport LLC · Raleigh, NCN379VMShores Kenneth E · Robstown, TXN37HDynamic Avlease Inc · Bridgewater, VAN3805EHollow Creek Investments LLC · Germantown, TN
Back to AD 2002-01-10