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.
N6186VFloriflt LLC · Daytona Beach, FLN6186WWerren Carroll E · Concord, NHFirst renewal noticeN61870Dfu LLC · Boise, IDN61872Griffith William C III · Indianapolis, INN61873Umo Seneca LLC · Raleigh, NCN61875Knight Aviation I LLC · Prescott, AZN61876Ferrara James L Jr · Wellington, NVN61878Tate John M · Boonton, NJN61879Lake Elmo Aero LLC · Lake Elmo, MNN6187JSky King Farmer LLC · Bentleyville, PAN6187PFlowers Ricky B · Klamath Falls, ORN6187WAerospace Trust Management LLC Trustee · Wilmington, DEN6187YSilver Creek Aviation Services · Fort Worth, TXN61884Purfield Sara E · West Richland, WAN61889Registration Pending · Dallas, PARegistration pendingN6188BSilver Creek Aviation Services · Fort Worth, TXN6188JRaveesh Cn · Gladstone, MIN6188PFair Robert A · Bradford, PAN6188QSilver Creek Aviation Services · Fort Worth, TXN6188TVargon LLC · Towson, MDN61890Stallion Leasing LLC · Louisville, KYN61891Higgins Jerome N · Oak Harbor, WAN61892Loughridge Robert M III · Prattville, ALN6189LKnutson Nathan J · Dubuque, IAN6189QParamus Flying Club Inc · Fairfield, NJN6189ZHall William B · Vincentown, NJN618ARoberts Jeffrey M · Markleville, INN618BSBauer Thomas G · Sturgeon Bay, WIN618CCU S Department Of Interior · Boise, IDN618DCrockett Brandon A · Hollis Center, MEN618DHCorsair Aviation LLC · Pacoima, CAN618DVVance Donn D · Monterey, TNN618EMMoffitt Michael E · Kent, IAN618EPEpic Aviation Inc · New Smyrna Beach, FLN618FLDexter Development LLC · Kingfield, MEN618FTFlorida Institute Of Technology · Melbourne, FLN618JMaldonado Jose Ivan · Hahira, GAN618JKAiuto James J · Sterling Heights, MIN618JMSkyknight LLC · Greeneville, TNN618JWMeriden Flyers LLC · Middlefield, CTN618KBCreech David W · Oriental, NCN618MJJuelfs Mark R · Faribault, MNN618MNEack Kenneth B · White Rock, NMN618NDUniversity Of North Dakota · Grand Forks, NDN618PMSieh Family LLC · Soldotna, AKN618RJDr Ghods Dmd Inc · Las Vegas, NVN618RLLynn Robert W · Independence, WVN618SWLang Marcus J · Hagatna, GUN618TMTuskegee Airmen National Historical Museum · Detroit, MIN618VCRaevin Aviation LLC · Bellmore, NY
Back to AD 81-18-04 R2