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.
N6768RTaylor Bradley K · Muskego, WIN6768UBranson Randel L · Eclectic, ALN6768WCimeira Aviation LLC · Birmingham, ALN6769JHanson Tobin S · Westlake, ORN6769NCausey Kevin L · Bainbridge, GAN6769PKroll Richard L · Montague, MIN6769UWard Leonard · Preston, IDN676APiper Archer Three LLC · Wilmington, DEN676AKDillard Clayton B · Talkeetna, AKN676CBElizabeth City State University · Elizabeth City, NCN676CHTake Off Aviation Services LLC · Rockledge, FLN676CPCivil Air Patrol · Maxwell Afb, ALN676DWSunrise Aviation Inc · Ormond Beach, FLN676ECCastle Joseph E · Marietta, OHN676EREmbry-Riddle Aeronautical University Inc · Prescott, AZN676FLEdwards William J · Big Rapids, MIN676HWinterbottom Eric A · Beavercrk Twp, OHN676MMButler Nathaniel J · West Fargo, NDN676NLoftus Timothy P · Mclean, VAN676QKeil Urban G · The Villages, FLN676SECircle K Aircraft Leasing LLC · Houston, TXN676TFAeon62 Holdings LLC · Plano, TXN676WLeymaster Michael J · Westerville, OHN676YMarvin James · La Verkin, UTN67701R&R Aero Services LLC · Eden Prairie, MNN67705Registration Pending · Tacoma, WARegistration pendingN67708Pischel Tom K · Meadow Vista, CAN6770NGrant William S · Azle, TXN6770VDobalian Vaughn E · Jacksonville Beach, FLN67710Hillsboro Aero Academy LLC · Hillsboro, ORN67711Cox Linda M · Christiana, TNFirst renewal noticeN6771FDecruz Enterprises LLC · Hattiesburg, MSN6771PBach Keith · Hilton Head Island, SCN6771VBrice Michael · Dickinson, NDN67728Edj Aviation Ltd · Fort Myers Beach, FLN6772JMaljanion Mark D · Upton, MAN6772NHapp Michael E · Valley Center, KSN6772WKolb Lowell E · Rapid City, SDN67733Righter Douglas D · Bellingham, WAN6773JTuskegee Airmen National Historical Museum Inc · Detroit, MIN6773NMills David J · Combine, TXN6773VSouthern Mooney Inc · Wilmington, DEN67746Air-Planes LLC · Soddy Daisy, TNN6774BLegacy Aviation And Sales LLC · Ririe, IDN6774PWw LLC · Sioux Falls, SDN6774UFair Weather Holdings LLC · Centennial, CON6774W10-4 Aviation LLC · Waco, TXN67753Southwinds Export Inc · Kissimmee, FLN6775BOcean Aerial Ads Inc · Berlin, MDN6775FPittsburgh Flying Club Inc · Greensburg, PA
Back to AD 81-18-04 R2