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.
N128ACCga Holdings LLC · Kalispell, MTN128ARGeorge'S Aviation Services Inc · Honolulu, HIN128CPMaule Flight Inc · Moultrie, GAN128DHMorris Thomas E · Orlando, FLN128ESturges John A · Hayden, IDN128EHJen Air LLC · Greenwood, MSN128GRJaques Stanley S · Cassville, MON128KMScott Mark A · Newman Lake, WAN128KRRogue Texan Outfitters LLC · Skidmore, TXN128LFLewis Michael D · Jenks, OKN128MBParker Rodger D · Sedona, AZN128MGHastings Gladstone E · Miramar, FLN128MTMiddle Tennessee State University · Murfreesboro, TNN128PTaddeo Brent J · Cumming, GAN128PBHayes Thomas G · Kerrville, TXN128PHWayne Terry · Belews Creek, NCN128PSShoen Paul F · Gardnerville, NVN128SAFly-Right Aviation LLC · Anderson, SCN128SCIasco Flight Training Inc · Redding, CAN128SHCalifornia In Nice Inc DBA · San Jose, CAN128TBlakesmith Don G · London Mills, ILN128VMThomas Lucas G · Beebe, ARN128VUTiger 2 Flying Club LLC · Geneseo, ILN128WPPatterson Weldon E · Maryville, TNN128YGorge Flight LLC · White Salmon, WAN1290JKrister Robert A · Kent, OHN1292CTrout Island Transit LLC · Glen Ellyn, ILN1292JSoutheast Michigan Aircraft Sales Inc · Blissfield, MIN1292XBurns Barry D · Amarillo, TXN1293TN1293t LLC · Wilmington, DEN1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeN1294XMcglynn Brian · Friday Harbor, WAN1295TLutz Brian · Carmel, INN1295XOz Aviation Inc · Cottonwood Falls, KSN1296CLogan Tom B Trustee · Coeur D Alene, IDN1296XFox Judy · Ridgefield, WAN1297JLemrich Aero Inc · Dallas, TXN1297TReich David W · Fort Lauderdale, FLN1297XScott Benjamin D · Grove City, OHN12984Go Fly Az LLC · Gilbert, AZN1299AHunsicker Greg A · Berryton, KSN1299XMunoz David · Corona, CAN1299ZWojdac David E · Mosinee, WIN129AGMarsh Equipment LLC · Aurora, ORN129AXBradley William R · Colorado Springs, CON129BAAdvise By Air LLC · Whittier, CAN129BBLawson Michael · Englewood, TNN129CCChilds David E · Amber, OKN129CPUpright Aviation LLC · Helena, MTN129GCBlue Air Training Corp · Las Vegas, NV
Back to AD 2006-10-21