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.
N7932NMyers Richard J · Lebanon, TNN7932WBlaine Richard A Jr · Boardman, OHN79330Prater Kerrie J · Maurice, LAN79331Harbour Aviation LLC · Weatherford, TXN79334Lewis Troy D · Clarkston, MIN79337Thoreson Alvin J · Granada, MNN79338Baber Fredrick Marshall · Punta Gorda, FLN7933CLaytham Ricky A · Coatesville, PAN7933HNeal Clarence W · Markham, TXN7933NCc Aero Services LLC · Bullard, TXN7933PFoss Rick · Lemmon, SDN79340Windsperger Kevin L · Kirksville, MON79341Sigmon Thomas W · Surprise, AZN79344Seley Ronald J · South Pasadena, CAN79346Chandler John · San Gabriel, CAN79347Aguilar William A · Puyallup, WAN7934G7550g LLC · Birmingham, MIN7934WAir Roanoke Ltd · Roanoke, VAN79350Ocala Aviation Services Inc · Ocala, FLN79351Dust Devils Aviation LLC · Richland, WAN79358Henderson Steven R · Madison, WIN79359Schultz Steven R · Tea, SDN7935CRfc Inc · Hiawatha, IAN7935NTorrington Flying Club Inc · Torrington, WYN7935PBarnett Michael DBA · The Woodlands, TXN7935WRather Be Flying LLC · New Castle, DEN79360Lewis Robert T · Avondale, AZN79361Narayan Systems LLC · Dayton, OHN79362Esfandiari Ozra · Las Vegas, NVN79363Holmes Shaun B · Georgetown, TXN79365Durden Bobby D Jr · Statesboro, GAN79368Jmr Investments LLC · San Antonio, TXN7936GWatson Carlton D · Campbellsville, KYN7936PHawkins Robert J · Lamesa, TXN7936WHiller Jeron P · Marshfield, WIN79374Johnson Stephen C · Columbus, OHN79378Janoski David Michael · Fort Worth, TXN7937PMr Dent Inc · Manheim, PAN7937WYang Zhongyi Deroll · Oro Valley, AZN79380Marr Steven K · Saint Charles, MON79382Hood Gary L · New Caney, TXN79383De Michele Fabio Jose Delgado · Pembroke Pines, FLN79387Luckenbach Adam W · Friendswood, TXN79388Mulligan Lawrence · Murray Hill, NJN7938CVolar Corp · El Cajon, CAN7938GDelaney Patrick James · Marion, TXN7938MSanders David D · Alvin, TXN7938PWardly George A · Ridgewood, NJN7938WPiper Club LLC · Atkinson, NEN7938YEai Aircraft LLC · Fairbury, NE
Back to AD 81-18-04 R2