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.
N864EBudner Jeffrey B · Rio Vista, CAN864GBenson Brad · Mamou, LAN864GCRotor Leasing LLC · Indianapolis, INN864JBouchard Cary T · Washburn, WIN864MSwingle Howard D · Blacksburg, VAN864PAs6 Aero LLC · Kalispell, MTN864PUTrustees Of Purdue University · West Lafayette, INN864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeN864TWTailwinds Academy Of Aviation · Philadelphia, PAN864VLVieques Air Link Inc · San Juan, PRN865Birge Stuart M · Charlotte, NCN8650CMalan Desiree · Anchorage, AKN8650EGotta Fly LLC · Manitou Springs, CON8650NAllen Flight Service LLC · Laredo, TXN8651CDoby Julian · Graham, NCN8651ESchoen Michael · Lakeville, MNN8651PGottschall Kenneth Lee III · Santa Paula, CAN8652WCass Michael Norman · Moscow, IDN8653Rempel Warren K · Longmont, CON8653VLarson Paul E · Palmer, AKN8653WZook James E · Holt, MIN8653YMorris Equipment LLC · Yuma, AZN8654PRoman Louis · Bridgeport, CTN8654WJordan Kenneth J · The Villages, FLN8655CBraun Ronald J · Wasilla, AKN8655WGtj LLC · Johnston, IAN8656GRut-Roh Flyers LLC · Greer, SCN8656LAdirondack Soaring Association Inc · Ballston Spa, NYN8656NN8656n LLC · Weston, NEN8656PMcdonald Gregory S · Mena, ARN86571Houck Steven E · Fairbanks, AKFirst renewal noticeN86573Phoenix Aviation Services Inc · Miami, FLN86574Kern Hunter S · Anchorage, AKN86576Pirkle Anthony E · Theodore, ALN86578Halpin Aviation · Eden Prairie, MNN86579Youngs William D Jr · Moravia, NYN8657DParks John T · Ripon, WIN8657PSchoolcraft Carl L · West Harrison, INN8657VFrahm Michael T · Willow, AKN86582Sale Reported · Oxford, IASale reportedN86583Merrell Glen R · Eatonton, GAN86585Birchler Judy A · Indianapolis, INN86588Roberts Todd L · Friday Harbor, WAN8658LMid Atlantic Soaring Association Inc · Frederick, MDN86591River Aviation Consulting LLC · Lake Havasu City, AZN86592Landry Matthew A · Soldotna, AKN86594Beadle Scott · Fort Worth, TXN86595Coker Janie K · Tyler, TXN8659CBraddock Randall C · Syracuse, KSN8659EKuehn Ricky A · Mesa, AZ
Back to AD 81-18-04 R2