AD 48-50-01
Registered aircraft · 623
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:48-50-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-50-01')
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:48-50-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-50-01') 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.
N40177Dyrstad William M · Hampshire, ILN40179Gonzalez Alexander D · Miami, FLN40181Bear Thomas A · North Hampton, NHN40182Trudnak Michael W · Mansfield Center, CTN40185Bosko Steven J · San Ramon, CAN401WRRiddell Warren L · Westbrook, MNN408Jasinski Jack J · Necedah, WIN411Kepler Justin W · Nikolaevsk, AKFirst renewal noticeN412First State Ag Air Inc · Viola, DEN413CWalters Thomas D · Winnsboro, TXN427Olson Wesley M · Clovis, NMN43XMajor Ken'S Flying Service LLC · Colfax, NDN44BSSorensen Raymond D · Anchorage, AKN47614Trombley Steve DBA · Worland, WYN584LWWheelock Larry A · Raymondville, TXN5GTMeyers Mark R · Ocean Shores, WAN63XPutney Bruce N · Midlothian, TXN6504NBrown Justin G · Folsom, CAN6506NThoms Robert D · Clyde, MIN6507NEack Kenneth B · White Rock, NMN6508NRegistration Pending · Independence, ORRegistration pendingN6668ELeclere Doug D · Coggon, IAN6751MEisenbrey Glen T · Greenbank, WAN71XPetram William A Trustee · Willow, AKN734SCCarden Keith B · Irvington, ALN73KVlk Mark J · Moses Lake, WAN74213Mullins Mike W · Marshall, TXN74220Grzeskowiak Robert J · Tioga, NDN74221South Carolina Aviation Museum Ltd · Wilmington, DEN74223Mid Atlantic Air Museum · Reading, PAN74228King John D · Midland, VAN74231Valkyrie Wings LLC · Springville, UTN74235Thorpe Brian J · Saint Augustine, FLN74241Hoover Ronald L · Springfield, MON74266Stephenson Gary E · Philip, SDN74267Siler Martin R · Macon, GAN74269Tanner Paul Leslie · Savoy, TXN74283Kelly Stephen M · Stonington, CTN74295Snavely William R · Lake Placid, FLN74297Williams David A · Whitewater, WIN74299Doe Gregory P · Smyrna, TNN74314Dale John V · Sahuarita, AZN74337US Flight Academy International Inc DBA · Post, TXN74360Carboneau Luke · Las Cruces, NMN74363Brewington Carl W · Roswell, NMN74364Brannon Lawrence A · Placentia, CAN74376Vlk Mark J · Moses Lake, WAN74378Goldschmidt Michael · Swanzey, NHN74380Allen Ken · Shelby, NCN74384Record John · Perham, ME
Back to AD 48-50-01