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.
N6862WFly Dynasty Corp · Ocala, FLN6862ZSimmons Aviation Services LLC · Pawcatuck, CTN6863FKaminski Joseph J · Port Orange, FLN6863TBering Capital LLC · Anchorage, AKN6863UHoppe Joel A · Mankato, MNN6863WThrust Vector LLC · Austin, TXFirst renewal noticeN6864HMay Jeffrey N · Ocala, FLN6864KMedina-Solla Edwin O · Trujillo Alto, PRN6864NStensen Craig J · Mount Juliet, TNN6865AAtp Aircraft 7 LLC · Wilmington, DEN6865BEllis Ray Lynn · Lakeside, CAN6865KSvendsen Jon · Wasilla, AKN6865NRegistered aircraftN6865WGraves William · Highlands, TXN6866HParrish Michael C Trustee · Lakeland, FLN6866NMancini Peter A · Kenmore, NYN6866PDeckard Kyle R · Harrisburg, ORN6867BMarx Nathan L · Sauk City, WIFirst renewal noticeN6867JOtmane Lahouari · Orlando, FLN6867KFloyd Roger L · Sedan, KSN6867NKnox Robert W Jr · Hazlehurst, GAN6867UMesquite Metro Flying Club · Dallas, TXN68680Willat Bret G · Warner Springs, CAN68688Registered aircraftN6868KFlamingo Air Inc · Cincinnati, OHN6868ZC-Fleet LLC · Missoula, MTN68690Locaero Services Inc Trustee · Wilmington, DEN6869JNa Aviation LLC · Mount Vernon, OHN6869KFelix Leonard D Jr · Salome, AZN6869TCsa Aircraft Leasing LLC · Salt Lake City, UTN6869UHostetler Kevin J · Green Forest, ARN6869WRegistered aircraftN686ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN686CACoast Flight Training And Management Inc · Dallas, TXN686JMavity Michael D · Phoenix, AZN686JAHot Wings Aviation LLC · Indianapolis, INN686JB92nd W Aviation Inc · Lonoke, ARN686JCRepublic Aircraft Leasing LLC · Ocala, FLN686LHChristiansen Aviation LLC · Wilmington, DEN686MSLauney Aviation LLC · Sacramento, CAN686NDUnd Aerospace Foundation · Grand Forks, NDN686PXTextron Aviation Employees Flying Club Inc · Wichita, KSN686RJEsplin Rulon Gregory · Nampa, IDN686RWBetancourt Ernest B · Lascassas, TNN686SLRatzburg Mark · Madison, WIN686SPRainier Flight Service LLC · Renton, WAN686XXHerbert Terry L · Chandler, AZN6870JCentral Minnesota Aviation LLC · Paynesville, MNN6870KYruegas Luis Jr · San Antonio, TXN6870LBarr Air Patrol LLC · Mesquite, TX
Back to AD 81-18-04 R2