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.
N7490FDodson International Parts Inc · Rantoul, KSN7490PRobinson John W · Ten Mile, TNN7490WCome Fly With Me LLC · Columbiana, ALN74911Aerial Messages Leasing Co · Longwood, FLN74912Sky Sailing Inc · Warner Springs, CAN74913Street Raymond E Jr Trustee · Fort Worth, TXN74914Tachoir Steven E · Marienville, PAN74919Braden John H · Watseka, ILN7491GAccess Air Service Inc · Mercedita, PRN7491KGidzinski Daniel P · Campbellsburg, KYN7491WWillard Michael W · Boonville, NCN74922Sale Reported · Anchorage, AKSale reportedN74924Rs Specialties LLC · Anchorage, AKN74929Shadbolt George Q · Merriman, NEN7492FHouston Police Dept · Houston, TXN7492JClassic Air Aviation LLC · Mesa, AZN7492PCache Rentals 401k P.S.P. · Greeley, CON7492WN7492w LLC · Spicewood, TXN74935Mcevoy Richard D Trustee · Anchorage, AKN7493FHouston Police Dept · Houston, TXN7493GHaugo Robert P · Scobey, MTN7493JRegistered aircraftN7493PBassar Michael · Eagle, MIN7493RWalcher James W · Wilmington, ILN7493WNonn Lidia G · Appleton, WIN74945Wright Sherry L · Buhl, IDN7494KWeaver Marvin Thomas · Kalispell, MTN7494PM And P Aviation Inc · Albia, IAN7494WLandreth Homer W · Peoria, AZN7494YRay James O III · Mc Rae, GAN74954Willis Andrew B · Wasilla, AKN7495JDreamair LLC · Fargo, NDN7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationN74960Smith Wallace B · Fairbanks, AKN74964Air Dakota Flite Inc · Hettinger, NDN74967Owens Sara R · Casper, WYN74968Niesen Isaac W · Nikiski, AKN7496DLeggett Brandon · Eola, TXN7496PS & S Air Inc · Wilmington, DEN74979Johnson Warren E · Kenai, AKN7497PLift Aircraft LLC · Carmel, INN7497TLeffler Greg L · Zion Crossroads, VAN7498JSawyer Steven A Md · Hampton, GAN7498PKarnegis Frank J · Senoia, GAN74990Berry Stanley W · Reddick, FLN74996Seward Air Taxi LLC · Seward, AKN74998White Jacob E · Delta Junction, AKN7499KBarnes Darin L · Wasilla, AKN7499PTri-C Farms · Tompkinsville, KYN7499RCart Caleb L · Eunice, LA
Back to AD 81-18-04 R2