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.
N6886NSibille Keith Curtis · Griffin, GAN6886PBas Part Sales LLC · Greeley, CON6886UN6886u Inc · Tucson, AZN6886WGregory Joshua L · Oxford, MSN6887JBas Part Sales LLC · Greeley, CON6887NColton Frank Lasusa · Harrisburg, PAN6887UAce Aircraft Leasing Inc · Nazareth, PAN6888BVenell Farms Inc · Corvallis, ORN6888DCenter Charles C · Wasilla, AKN6888HN6888h LLC · Wayne, NJN6888NGrass James Conrad · Phoenix, AZN6888PKempf Douglas A · La Center, WAN6888WAnderson Ty M · Grenada, MSN688AAAoa Kissimmee Inc · Kissimmee, FLN688AMFox Three Holdings LLC · Waukee, IAN688BGJones William E · Birmingham, ALN688CABetter Southlake Properties LLC · Pagosa Springs, CON688CMIcan Solutions LLC · Fargo, NDN688HZumbrun Dennis L · Montz, LAN688KKing William K · Rockwall, TXN688LHChristiansen Aviation LLC · Wilmington, DEN688NDUnd Aerospace Foundation · Grand Forks, NDN688PAJoe P Fassio · Union, WAN688PGGo Blue Sky LLC · Trinity, TXN688RMBurton Jason S · Howell, MIN688TAircapital Nevada Inc · Carson City, NVN6890LTop Tier Truck And Trailer LLC · Dimmitt, TXN6890PMarble Jere D · Dayton, NVN6890RBudgeon Mark K · Mandeville, LAN6890WRegistered aircraftN6891BSchachle Theodore A · Willow, AKN6891HRegistration Pending · Uvalde, TXRegistration pendingN6891PWoods Eric V · Fort Washington, MDN68920Richmor Aviation Inc · Hudson, NYN68926Wings Over Texas Holdings LLC · Denton, TXN6892JHunter Trevor C · N Ogden, UTN6892NStratte Joseph J V · Yakima, WAN6892WRussell Steven D · Waxhaw, NCN6892YSaliani John · Lake Havasu City, AZN68931Denman Diana L · Plain, WIN68934Bapes Debra L · Powell, OHN68938Wingspan 152 LLC · Valparaiso, INN6893EArmstrong Bruce · Port Orchard, WAN6893FAligence Air LLC · Spring Hill, FLN6893URk Management LLC · Garden City, KSN6893ZAg Air Squadron Three LLC · Saint Joseph, ILN6894GSouthwest Aviation · Marshall, MNN6894JPiontek Theodore J · Housatonic, MAN6894SMk Aviation LLC · Charlotte, NCN6894UShonrock Clinton O · Los Alamos, NM
Back to AD 81-18-04 R2