AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N408FLSmith Benson H · Herington, KSN408GHMcdowell Kevin A · Tumwater, WAN408HCFarview Holdings LLC · San Francisco, CAN408JCN408jc LLC · Scottsdale, AZN408JMRobinson Wayne D · Highlands Ranch, CON408LBM & G Aircraft Management LLC · Englewood, CON408LJHuston Craig C · Keokuk, IAN408LTDecathlon LLC · Lincoln, NEN408PBBaich Michael V · Bovey, MNN408PTRegistered aircraftN408RStone Aviation LLC · Cusick, WAN408RGGould Rod · Milford, IAN408ZAlpha Tango Aircraft LLC · Wilmington, DEN408ZWLinett Michael J · Elsmere, DEN40903Boyer Aviation LLC · Kiel, WIN40904Allred Klein Enterprise LLC · San Diego, CAN40905Martin James Christopher · South Jordan, UTN4090ATop Gun Aviation Group Inc · Santa Monica, CAN4090EAerodrome LLC · Louisville, KYN4090HSouthern Air Transport Services LLC · Dover, DEN4090SByerly Brooks · Plano, TXN4091GRobinson Brant Fitzgerald · Powder Springs, GAN4091PPaulay Sandor F · Kenmore, WAN4091SBeechcraft Heritage Museum · Tullahoma, TNN4091ZA G Sholton Co · Wasilla, AKN40925High Flight Academy LLC · Allison Park, PAN4092TEnnyx LLC · Clermont, FLN40935International Air Services Inc Trustee · Carson City, NVN40936Aerial Sign North Inc · Lakewood, NJN40939Grog Holdings LLC · Dallas, TXN4093DZito Nick D · Ellensburg, WAN4093EDmkr LLC · Coronado, CAN4093PLumley John J · Delray Beach, FLN4093XBartholomeo Daryl A · Cleveland, OKN40945Mount Eagle Inc · Alexander, ARN4094BClosson Luke E Jr · Valdosta, GAN4094DManker Lance M · North Platte, NEN4094PShelley Isaac R · Scottsville, VAN4094S4094s LLC · Holly, MIN40951Grant Constance R Trustee · Eaton, INN40953Cws Capital Holdings LLC · Saint Petersburg, FLN4095AValiair Limited Company Trustee · Casper, WYN4095DRedfern Ronnie M · Fairbanks, AKN4095PTorell Pamela O · Port Saint Lucie, FLN4095ZBreidenbach Bros Inc · Iliff, CON40963Grant Matthew D · Alvord, TXN40965Portsmouth Flying Club LLC · Epsom, NHN40966Skytech Hc Ltd · Fredericksburg, OHN40967Mcbroom Darrin · Des Moines, IAN40969Papa Bravo LLC · Decatur, AL
Back to AD 2007-04-19 R1