AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N898JRKokosa Vernon R · Dennis, MAN898JWWeiswasser Jonathan M · Montclair, NJN898NDKleyn Transportation LLC · Grand Rapids, MIN898PTitus Aviation LLC · Fresno, CAN898RVAcree Joseph R · Calhoun, GAN898SCBmsb Aviation LLC · Bogart, GAN898SEFrieling Judson D · Houston, TXN898TTMayes Kevin A · Rockwall, TXN8990FDeon Esterhuizen Inc · Clearwater, FLN8990JStites Charles Harold · Chapel Hill, NCN8990PBaitanator Inc · Lamesa, TXN8991JCavoto Allyn E III · Adrian, PAN8991PCendejas Agustin · Chino, CAN8991YWaldemar Mojica · Arecibo, PRN8992JMid-Atlantic Air Ventures Inc · Richmond, VAN8992NBenedict Kevin M · Lakeland, FLN8992PL And L Aviation Inc · Mount Airy, MDN8992RBcm Consulting Inc · Wilmington, DEN8992VFreeze Otis C · Frankston, TXN8992WKelk Investment Management LLC · Lake Tomahawk, WIN8993DKey James M · Hermiston, ORN8993JHealy Law Offices Pc · Tyler, TXN8993PPitcher Benjamin Alan · Fishers, INN8993RMiller 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, FLN8996EHooligan Air LLC · Ponce Inlet, FLN8996NBickford Shawn A · Auburn, CAN8996VBaumgartner Scot W · Colby, WIN8996WVan Seghbroeck Jeffrey A · Zion Crossroads, VAN8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedN8997DFinley Peter T · Bismarck, NDN8997JKakuska Michael · Madison, WIN8997PF2 Management LLC · Canoga Park, CAN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN8997WDockers Elite Aviation LLC · Towanda, KSN8998EGeorgetson Michael J · Sayre, PAN8998JObrien Robert · Warrens, WIN8998NHangar Cc5 LLC · Gainesville, GAN8998PMoore Jeffrey · Oceanside, CAN89994Lon Aviation LLC · Aspen, CON8999DPadgett Benjamin C · Anchorage, AKN8999PBednorski Craig A Trustee · Grass Valley, CAN8999RDetroit Lakes Aviation Inc · Detroit Lakes, MN
Back to AD 87-10-06 R1