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.
N373EBRudling Peder · Simi Valley, CAN373EWBaker Sheryl Wolff · Elbert, CON373GTCruisaire Inc · Port Orange, FLN373HShumate Johnny E · Spring, TXN373JWSousek Samuel V II · Shawano, WIN373LEWoodley Judson · Comanche, TXN373MBBurks Michael S · Haslet, TXN373MKNorth Star Aviation · Mankato, MNN373PJRock Creek Corp · Henderson, NVN373RPHoward Mark C · Edmond, OKN373SAnderson Thomas · Brooklyn, NYN373SAValiair Lc Trustee · Casper, WYN373SERegistration Pending · Phoenix, AZRegistration pendingN373STLassen Peter C · Ventura, CAN373TBarker Philippe · San Leon, TXN373ZEvans Dale A · Green Cove Springs, FLN37402Viking Construction Inc · Hayden Lake, IDN3740TBibbey Mark A · Chandler, AZN3740UFlight Club 502 Inc · Louisville, KYN3740XBarnato Peter M · Twain Harte, CAN3740YOmg Air LLC · Okeechobee, FLN3740ZCarl Eric Storm Trustee · Eagle River, AKN3741APrice John C · Bennington, KSN3741BCherokee Trail Aviation LLC · Tontitown, ARN3741COmr Investments LLC · Dawson, GAN3741DTrouwborst Keith J · Lander, WYN3741TIowair Inc DBA · Atkins, IAN3741ZStanton Morgan · Anchorage, AKN3742FBenson Edward A · San Antonio, TXN3742QVives David A · Valdosta, GAN3742WRibas Daniel · Atascadero, CAN3742XHancock John R · Poplarville, MSN3743DLanzisera Francesco · Questa, NMN3743PBulldog Aviation LLC · Ely, MNN3743QTonneson Rollin J · Souris, NDN3743UHughes Kathryn G · Council, IDN3743XHenderson Douglas A · Springerville, AZN3743YCooper Jess D · Spanaway, WAN3744CVand Flyve Klub Inc · Thief River Falls, MNN3744DMorcom Ronald W Jr · Stanwood, WAN3744GValiair Limited Co Trustee · Casper, WYN3744PCaplinger Jimmy C · Justin, TXN3744TAg Air Squadron One LLC · Saint Joseph, ILN3744XLongwill Dusty J · Raton, NMN3744YKt 2022 LLC · Broomfield, CON3744ZWild About Nature LLC · Fairbanks, AKN3745KMangels Christopher L · Wasilla, AKN3745PRiviera Aircraft Inc · Lewes, DEN3745THill James C · Grand Saline, TXN3745UAnglemyer Mark · Piketon, OH
Back to AD 2007-04-19 R1