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.
N8044WKananen Agency Inc · Joliet, MTN80454Tadao LLC · Tucson, AZN80456Barash Geva S · Ashland, MAN80458Kolpack Glenn H · Sonora, CAN8045CConrad Daniel R · Sweet Home, ORN8045DLarson Larry E · Twin Valley, MNN8045KEmerald City Aircraft Leasing Inc · Port Orchard, WAN8045NCti Aircraft Leasing LLC · Memphis, TNN8045PDuncan Mark L · Hyampom, CAN8045RCcf Ventures Inc · Bangor, MEN8045SHenry Mark A · Dickinson, TXN8045WOpen Engineering LLC · Ames, IAN80469Hetherly Bryce D · Clintondale, NYN8046RComputer Solutions Inc · Casper, WYN8046WMuthandi John M · Woodland, WAN80470Coddiwomple LLC · Newberg, ORN80471Dairy Air Inc · Wyoming, PAN80472Simons George Trustee · Bouse, AZN80475Texas Southern University · Houston, TXN80476Sky Roamers LLC · Columbus, NEN8047DMurphy Robert · Kent, WAN8047LHolmes Frank L · Enterprise, ALN8047WFlying Fossil LLC · Franklin, TNN80483Harrell Matthew J · Grand Haven, MIN80484Mor Aviation 172m LLC · Gaithersburg, MDN80486Romoser Carey E · Simpsonville, SCN80487Williams Fredrick Glen · Auburn, ALN80489P & K Aviation LLC · Neshkoro, WIN8048CDegraff Claude Md · Fort Myers, FLN8048DBarnstormers Aerial Advertising LLC · North Myrtle Beach, SCN8048PCoastal Virginia Aviation LLC · Chesapeake, VAN80490American Patrols Inc · Midland, TXN80491Duffys Aircraft Sales & Leasing Inc · Neillsville, WIN80495Space Coast Aero LLC · Melbourne, FLN80496Bickel Gregory A · Mckinleyville, CAN80497Ducksrus LLC · Indianapolis, INN8049DFerrell Alan B · Arlington, OHN8049GStone & Phillips Aviation LLC · Youngstown, FLN8049NKolbjornsen Arne · Middletown, DEN8049PFranklin Ricky L · Glade Hill, VAN8049WTennis Gayland L · Bath, MIN804ATFlight School Of Texas LLC · Wilmington, DEN804BD G Leasing LLC · Houston, TXN804BLFlores Omar Javier · New Braunfels, TXN804ERDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN804GASaber Safa · Newburyport, MAN804JSButler Jack L · Bennington, OKN804KSKansas State University · Salina, KSN804LGDem Ventures LLC · Wichita, KSN804NVMoody Bible Institute Of Chicago · Spokane, WA
Back to AD 81-18-04 R2