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.
N485MACunningham Richard · Justin, TXN485PALapointe Arthur L · Powder Springs, GAN485SBLyddon Aero Center Inc · Liberal, KSN485SYYoung Todd N · Mechanicsville, VAN485TMitchell Lisa Marie · Lake Villa, ILN485VL & W Leasing LLC · Smyrna, TNN4860AWolff Paul J · Baraboo, WIN4860BWeaver Dianna K · Benton, LAN4860UBoard Of Regents Of The University Of Oklahoma · Norman, OKN4860ZSewell Dennis L · Clay Center, KSN48610Redstone Arsenal Flying Activity · Redstone Arsenal, ALN48616Hall Stanley C · Sequim, WAN4861ARubbert Randy C · Reynolds, NDN4861GFlying Colors Airparts Inc · Leesburg, FLN4861LPodolinski Frank · Greensburg, PAN4861VRegistered aircraftN4862ASmith James A · Lyle, WAN4862LGunter Gordon D · Green River, WYN48637K S Aviation · Atwater, CAN4863ARud Alexandra E · Clara City, MNN4863LZimmerman Marlin · Muscoda, WIN4863ZIvy James H III · Seligman, AZN4864DChiota Aviation LLC · Waco, TXFirst renewal noticeN4864FFreely James John · Marshall, VAN4864GLazy Eights Holdings LLC · Greenwood, INN4864LRegistration Pending · Boone, NCRegistration pendingN48650Herion Chris W · Williamsburg, VAN48652Lorenz John C · Edgewood, NMN4865DBlack Hound Aviation LLC · Austin, TXN4865ZSchroer Steven K · Columbus, INN4866ECollier Charles R · Gloucester, VAN4867DFlynn Brian · Auburndale, FLN4867L23 Right LLC · Kalispell, MTN4868EVero Technical Support Inc · Pensacola, FLN4868LWinningham Matthew P · Prattville, ALN4868VKusy Edward James · Schulenburg, TXN48690Chamberlin William C · Williamsburg, MIN4869ANevill Bernard L · Clare, MIN4869LCentral Texas College · Killeen, TXN486BLBlue Line Aviation LLC · Smithfield, NCN486EMMason Edward R Trustee · Wilsonville, ORN486FLBaker Donnie · Christiana, TNN486JWWade James M · Calhoun City, MSN486KWilliams Lawrence J II · Tucson, AZN486MAOrange Wing Aviation Inc · Wilmington, DEN486PRichardson Joshua R · Mobile, ALN486PARegistered aircraftN486WCoyne Thomas E · Fort Collins, CON48708Greene Caleb M · Laverne, CAN4870DSherman Hess M · Poplar Grove, IL
Back to AD 90-04-06 R1