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.
N898NDKleyn Transportation LLC · Grand Rapids, MIN898PTitus Aviation LLC · Fresno, CAN898RVAcree Joseph R · Calhoun, GAN898SCBmsb Aviation LLC · Bogart, GAN898SEFrieling Judson D · Houston, TXN898SYGordon Brett · Ewa Beach, HIN898TTMayes Kevin A · Rockwall, TXN898WRegistered aircraftN8990FDeon Esterhuizen Inc · Clearwater, FLN8990JStites Charles Harold · Chapel Hill, NCN8991CSpicer Luke J · Seneca, SCN8991JCavoto Allyn E III · Adrian, PAN8991LSky Clock LLC · Mesa, AZN8991YWaldemar Mojica · Arecibo, PRN8992JMid-Atlantic Air Ventures Inc · Richmond, VAN8992RBcm Consulting Inc · Wilmington, DEN8992VFreeze Otis C · Frankston, TXN8992WKelk Investment Management LLC · Lake Tomahawk, WIN89933Sunrise Aviation Inc · Ormond Beach, FLN89934Sunrise Aviation Inc · Ormond Beach, FLN8993DKey James M · Hermiston, ORN8993JHealy Law Offices Pc · Tyler, TXN8993RMiller Scott A · Piney Flats, TNN8993VBmg Aviation Leasing LLC · Bloomington, INN8993YAirglas Inc · Anchorage, AKN8994JBatham Carin C · Yuba City, CAN8994RT & H Aviation LLC · Rector, ARN8994WLong Evertt W · Wichita, KSFirst renewal noticeN8995DGraham William Franklin III · Port Alsworth, AKN8995JBloomquist Eric R · Phoenix, AZN8995WBlair Maksim J · Pensacola, FLN89963Wardall Wesley David · Ione, CAN8996EHooligan Air LLC · Ponce Inlet, FLN8996VBaumgartner Scot W · Colby, WIN8996WVan Seghbroeck Jeffrey A · Zion Crossroads, VAN8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedN8997DFinley Peter T · Bismarck, NDN8997JKakuska Michael · Madison, WIN8997LBaldwin Rodger D · Decatur, ILN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN8997WDockers Elite Aviation LLC · Towanda, KSN89980Ace Aircraft Leasing Inc · Nazareth, PAN8998EGeorgetson Michael J · Sayre, PAN8998JObrien Robert · Warrens, WIN89994Lon Aviation LLC · Aspen, CON8999DPadgett Benjamin C · Anchorage, AKN8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNN8999WEagle Air LLC · Red Bud, ILN899AAAoa Kissimmee Inc · Kissimmee, FLN899AVGilbert Charles L · Belleair, FL
Back to AD 81-18-04 R2