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.
N6602PBertrand Paxton A · Melbourne, FLN6602RFagundes Farms · Hanford, CAN6602YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN66038Landrum Erik G · Austin, TXN6603JWorkman Karen L · Northfield, MNN6603PHales Kurt A · Washington, UTN66049Aerosync LLC · Miami, FLN6604EFlyn High Aviation LLC · Boynton Beach, FLN6604FEvolution Air LLC · Huntley, ILN6604PBrookhouser David L · Creighton, NEN6604UMr Dent Inc · Manheim, PAN6604WSedberry Jason A · Kokomo, INN66052Gerot David · Janesville, MNN6605DAlameda Aero Club · Alameda, CAN6605FPurdue Aviation LLC · West Lafayette, INN6605JPatton Janet · Denton, TXN6605PHillsboro Aero Academy LLC · Hillsboro, ORN6605RRegistered aircraftN6605UFoster Henry R · Saint George, SCN6605WChadwick Joseph G · Fayetteville, GAN6606DRegistration Pending · Sturgeon Bay, WIRegistration pendingN6606FWestfall William L · Sunbury, OHN6606JSale Reported · Warner Robins, GASale reported, canceledN6606WMobley Ray M Jr · Midlothian, TXN6607DVero Technical Support Inc · Pensacola, FLN6607LGll Plane LLC · Ocala, FLN6607PHaumesser Daniel T · Kenosha, WIN6607UN6607u LLC · Commerce City, CON66084Cummings Steven R Trustee · Wyarno, WYN6608BTucker William C · Phoenix, AZN6608DAmericus Flying Club Inc · Americus, GAN6608JGreat Lakes Aviation Services Inc · Kimball, MIN6608RBogovich Robert E · Clifton, TXN6608URb II LLC · Walker, MNN6608WGrant Hooks LLC · Middleburg, FLN66090Skyline Solutions Inc · Deland, FLN66091Ftg Leasing LLC · Watkins, CON66096Tippit Larry J · Grand Prairie, TXFirst renewal noticeN66097Gaskin Greg · Lake Almanor, CAN6609DCopperhead Environmental Consulting Inc · Paint Lick, KYN6609EClark Andrew M · Bend, ORN6609LUsda Aphis Ws · Cedar City, UTN660AAFms Bank · Fort Morgan, CON660DBAnderson Samuel D · Marana, AZN660FTFlorida Institute Of Technology Inc · Melbourne, FLN660JBBuilders Construction Services Inc · Touchet, WAN660PCObrien Kenneth J · Lafayette, CON660RWHay Johnny L · Bethel, OHN660SPRobert Devers Solutions · Hermosa Beach, CAN660SRAom Aircraft LLC · Orlando, FL
Back to AD 90-04-06 R1