AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N222LEHigh View Air LLC · Driftwood, TXN222LKCoulter Lance A · Meeker, CON222MMYount Patrick G · Buckeye, AZN222MNMeridian Aircraft LLC · Wilmington, DEN222MTJw182 LLC · Kalispell, MTN222NLLawson Lonnie B II · Linden, PAN222PFStokes Brian L · Boulder City, NVN222PJSchroeder James L · Rapid City, SDN222PPPreferred Landing LLC · Tomball, TXN222RACaptain Rick LLC · Miami Lakes, FLN222RJAmbrose James · Dyersburg, TNN222SNNorris Jason M · Smyrna, TNN222SPRobinson Avery Clark · Phoenix, AZN222TJSimmons Scott C · Pleasant Prairie, WIN222TRHarper David E · Stillwater, MNN222VBGalaxy Aviation LLC · Nantucket, MAN222VWCool Beans LLC · Newtown, PAN222WAWiseman Aviation Inc · Flagstaff, AZN222WBPower Robert R · Brenham, TXN222WGWalker Scott Aviation LLC · Woodward, OKN222WPFord Scott S · Punta Gorda, FLN222ZMPresentation Impact LLC · Sandia Park, NMN2230TWhite Pelican LLC · Union City, TNN2230XPoff Matthew W · Miramar Beach, FLN22316Mcleland David L · Sellersburg, INN2231JWares Auto Sales Inc · Traverse City, MIN2231MGreat Lakes Aviation Services Inc · Kimball, MIN2231XCaselato Andre Luiz Puls · Kissimmee, FLN2232Reigle Aviation · Palmyra, PAN22320B Lillico Petroleum Consultants Ltd · Eastport, IDN2232ASummit Air LLC · Clarks Summit, PAN2232NKnoll Guenter Wilhelm · Belton, SCN2232QStender Michael L · Davenport, IAN2232ZAlaverdi Omeed · California, MDN22336Goldshlager Benjamin · Boca Raton, FLN2233CFreeland Robert D · Victor, MTN2233LBecker Leo Henry · Leavenworth, KSN2233MPutnam John P · Weirsdale, FLN2233XSpector Arnold · Stamford, CTN2234FMoore Aviation LLC · Cedar Springs, MIN2234UMountain States Casing Co LLC · Timnath, CON2235CAnderson Nick A · Cynthiana, KYN2235LCarter Dale · Riga, MIN2235VE & R Aviation Services Inc · Long Beach, CAN22363Barnes Welding Inc · Waterville, WAN2236CAlexander James E Jr · Fort Worth, TXN2236UPrater Jon A · Palm Coast, FLN22370Top Flight Sales Inc · Wilmington, DEN2237AKimber 123 Holdings LLC · Morgantown, WVN2237LDeatherage Christina M · Goshen, OH
Back to AD 2006-10-21