AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N898GAtp Aircraft 9 LLC · Wilmington, DEN898JRKokosa Vernon R · Dennis, MAN898JWWeiswasser Jonathan M · Montclair, NJN898PTitus Aviation LLC · Fresno, CAN898SCBmsb Aviation LLC · Bogart, GAN898SYGordon 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, TXN89933Sunrise 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, ARN8995DGraham William Franklin III · Port Alsworth, AKN8995JBloomquist Eric R · Phoenix, AZN89963Wardall Wesley David · Ione, CAN8996EHooligan Air LLC · Ponce Inlet, FLN8996VBaumgartner Scot W · Colby, WIN8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedN8997DFinley Peter T · Bismarck, NDN8997JKakuska Michael · Madison, WIN8997LBaldwin Rodger D · Decatur, ILN8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEN89980Ace 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, MNN899AVGilbert Charles L · Belleair, FLN899CMMoore Andrew · Mills River, NCN899CVJolovich Matthew J · Cheyenne, WYN899DHSchiffer Patrick M · Ovid, MIFirst renewal noticeN899JDMiranda Michael R · Enterprise, ALN899JLMeise Wendell G · Port Orange, FLN899NRichards Vallin J · Spearfish, SDN899PGivens Steve · Pendleton, IN
Back to AD 90-04-06 R1