AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N5521QEckmann Sheri L · Santa Barbara, CAN5521SChristiansen Aviation LLC · Wilmington, DEN5521UMiller Groom Marie T · Rockford, ILN5521ZTessenear James A · Hopewell, VAN55220Ishii Kanji · Brooklyn, NYN5522A5522a LLC · Bethany, OKN5522KHall Dean A · Hyattsville, MDN5522QBarnhill Jerry D · Longville, LAN5522SAmeriflyers Of Texas Inc · Addison, TXN5522UAlbrecht Jeffrey N Trustee · Mount Horeb, WIN5522XChristiansen Aviation LLC · Wilmington, DEN5522ZWolfe Robert N · Rogers, TXN55231Golf November Aero LLC · Sunnyvale, CAN55234Alien Invaders LLC · Medina, WAN55236Bobnal LLC · Conway, SCN5523FSirko Frederick S · Portage, INN5523PBens Motorworks Inc · Fullerton, CAN5523QDolphin Leasing LLC · Daytona Beach, FLN5523RPlett John · Anaconda, MTN5523TCantrup Peter H · White Rock, NMN5523UKlein Michael · Gilsum, NHN5523VDolphin Leasing LLC · Daytona Beach, FLN55240General Associated Products Inc · San Lorenzo, CAN55242Hills Holding · Newark, DEN55244Wiechman Herbert · Boulder, CON55246Kadena Aero Club · Apo, APN55247Nordstrom Terry G · Scottsdale, AZN5524PSwarm Darryl J · Quincy, CAN5524QImwalle John N · Batavia, OHN5524SStellon Eugene A Jr · Burlington, CTN5524WHoe David S · Stafford, VAN55250Colorado Aircraft Corp · Watkins, CON55251Albatross Air Inc · Beaver, WVN55253Mccall Christopher J · Cocoa Beach, FLN55256Notam Aviation LLC · Portage Des Sioux, MON55259Heth Steven L · Westhope, NDN5525FCashion Thomas A · Mastic, NYN5525HStewarts Aircraft Service Inc · Waynesville, OHN5525JElliott James Richard · Florence, ALN5525KMacomber Donald Conrad · Santa Ynez, CAN5525WWells Nicholas · Dallas, TXN55260Weich Ronald L · El Paso, TXN55261Barton John S III · Gallatin, MON55263Fennell Donald H Jr · Hampstead, NCN55264Ace Aircraft Leasing Inc · Nazareth, PAN5526FLandry Raymond L · Stark, NHN5526JBravo Leasing LLC · Daytona Beach, FLN5526KOn-Site Aviation Inc · Hillsboro, NDN5526MEz Breezy Fc LLC · San Diego, CAN5526PWard County Irrigation District #1 · Barstow, TX
Back to AD 81-18-04 R2