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.
N7020WDavila Antonio · Cudjoe Key, FLN7020YMehrhoff Stanley E · Prairie Home, MON7020ZMeyering Clinton · Southgate, MIN7021BNewby Michael E · Pingree Grove, ILN7021WRichardson Garrett W · Mason, MIN7021YShira William G · Savannah, GAN70220Perun Av LLC · Cliffside Park, NJN70225Southeast Flight Leasing LLC · Cumming, GAN70228Eagle Sky Patrol Inc · Deadwood, SDN7022BSibille Keith C · Griffin, GAN7022QChant Savanah B · Baggs, WYN7022VCjsm LLC · Winter Haven, FLN7022WHall Wesley B · Hot Springs, ARN7022XGuy Jeffrey · Centerburg, OHFirst renewal noticeN7023PHanna Trenton W · Lakeland, FLN7023RPushpull LLC · Montgomery, TXN7023VJackson William G · Clinton, MDN7023YMaki Stephen B · New Port Richey, FLN7024BNelson Daniel D · Omaha, NEN7024PAnderson Richard · Dickson, TNN7024QWells Nathan S · Scotia, NEN7024TCorrigan Joseph M · San Marcos, CAN7024USpitzer Helicopter LLC · Woodland Hills, CAN7024YAnderson David J · Gardnerville, NVN70256Winn Edwin F · Louisville, KYN7025CDowning Gregg R · Guymon, OKN7025ELyon Emery F · Welsh, LAN7025TDavis Clint H · Paola, KSN7025USchultz Walter J · Pine Beach, NJN7025WBerberich Edward C · Gillette, NJN70267Evans Michael J · Rowlett, TXN7026DSfcaa LLC · Nashville, TNN7026KBryant Stephen C · Anchorage, AKN7026MLoerzel Loren · Blair, NEN7026RSanderson Eric R · Chelan, WAN7026UWilliams Mike C · Sonora, TXN7026WAdvanced Aviation Inc · Lakeville, MNN70275Christiansen Aviation LLC · Wilmington, DEN7027DHuriburt Ward · Dillingham, AKN7027KMorrison James II · Grandview, TXN7027QAero B Flying Service · Richards, MON7027VJohnson Marvin D · Gilbert, AZN70282Edwards Robert J · St Helena, CAN7028GKathol Donavin J · Hartington, NEN7028QBurns Michael S · Coplay, PAN7028RCuckler Jason Michael · Jenks, OKN7028WBlakely Richard S · Yerington, NVN7028YAces High Aviation Corp · Pembroke Pines, FLN7029KWillmeroth Wilbur D · Deland, FLN7029RBazzi Adel · Yorba Linda, CA
Back to AD 90-04-06 R1