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.
N7163WWings Over Lake Norman LLC · Mooresville, NCN7163YBoyd John W · Milton, WAN7163ZStull Simon M · Denver, PAN7164BRobinson Eric C · Palmer, AKN7164CD&J Aviation LLC · Apopka, FLN7164KSwanson Thomas J · Pukwana, SDN7164LOverby Ronald L · Eau Claire, WIN7164RGurley Brian M · Norman, OKN7164UKnapp Schuyler S K · Upperville, VAN7164WShort Final Aviation LLC · Branson, MON7164YGreat Lakes Air Ventures LLC · Mason, MIN7165GExecutive Flight Institute LLC · Murrieta, CAN7166DHewko Murray L · Ely, NVFirst renewal noticeN7166RRagains Frank H · White House, TNN7166WWhitney Albert C · Mission Viejo, CAN7166YCollum Aviation LLC · Milton, FLN7167BEsmailka Harold E · Ruby, AKN7167RPriewe Jeff C · Como, MSN7167WBuckley Barney P · Colfax, WAN7167YThomas Thomas J · Lewisburg, WVN7168GDurbin John W · Lovington, ILN7168HHindes Philip W DBA · Charlotte, TXN7168KDotzenroth David A · Watertown, MNN7168LAltaii Ali A · Gibraltar, MIN7168MWindh Steven R · Reedley, CAN7168PSchober Brian S · Scottsdale, AZN7168RParham Maxwell V · Madison, MSN7168UMorris Charles P · Uvalde, TXN7168WDestination Flyer LLC · Memphis, TNN7169BNorthern Peaks Flight Training LLC · Wasilla, AKN7169FPillar Aviation Services LLC · Auburn, NHN7169JWatson Terry D · Norman, OKN7169RBrock Charles Calvin Jr · Pendleton, SCN7169VPrh Farms Inc · Gettysburg, SDN716ABRice Flying LLC · Corning, ARN716ACAlexandrov Boyan · Reno, NVN716CNNordquist Conrad · Jurupa Valley, CAN716CPCivil Air Patrol · Maxwell Afb, ALN716DCHesano Joseph M · Rockford, ILN716EPEpic Flight Academy Inc · New Smyrna Beach, FLN716ERFly With Bruno LLC · Mountainside, NJN716GAtp Aircraft 9 LLC · Wilmington, DEN716HPState Of Ohio · Columbus, OHN716JJKeenum Jc · Loveland, CON716JLTrack D LLC · Talkeetna, AKN716KUrbanczyk Kirk M · Draper, UTN716LULiberty University · Lynchburg, VAN716LWWigley Eddie G · Howell, MIN716MUS Department Of The Interior · Boise, IDN716MCWing & A Prayer LLC · Wilmington, DE
Back to AD 81-18-04 R2