AD 90-04-06 R1
Registered aircraft · 68,375
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.
N2684AMckinley I Blake Jr · Spokane Valley, WAN2684GBlair Daniel S · Perrysburg, OHN2684TGallaher Matthew · Anchorage, AKN26850Palm Michael · Middletown, RIN26855Clarke George W · Sierra Vista, AZN26856Reed David A Trustee · Pinedale, WYN26860Robinson Andrew T · South Windsor, CTN26868Musser Alvin M Jr · Memphis, MON2686AJohnson James L · Greenville, TXN2686MCummings Scott Alan · Monitor, WAN2686TGoddard John · Penokee, KSN26872Hughes Tool & Die LLC · Norfolk, VAN26874Sale Reported · Sacramento, CASale reported, pending cancellationN26875Yin Steve · Del Mar, CAN2687MWilkes Gary W · Lakeland, FLN2687THolley Ronald E · Hastings, MIN2687ZSchaefer Richard T · Marble Falls, TXN26880Sinclair Ian · Pembroker, NYN26887Patel Ronik M · Pearland, TXN26888Mcguire Eric · Weare, NHN2688ALanham Rex E · Boise, IDN2688BScott Fred · Greencastle, INN2688VHampel Michael J · Camas, WAN26894Moore Altitude LLC · Lake Saint Louis, MON26896Magnus Air Ct LLC · Manchester, CTN26899Gibson Daniel W · San Marcos, TXN2689AWomack W A · Jackson, LAN2689MKuehni Steven A · Stanley, WIN2689WLocke Timothy S · Fort Irwin, CAN268BGHuff Holdings LLC · Ashland, KYN268BHJett Cory L · Floyds Knobs, INN268CRMaxcy Christopher L · Bozeman, MTN268DASpartan Education LLC · Tulsa, OKN268JGSpero Bruce A · Carson City, NVN268LChilton Darren M · Pottsboro, TXN268MAMasters Of The Air LLC · Salt Lake City, UTN268MCRegistered aircraftN268MERegistered aircraftN268MGGeorgia Aviation Authority · Eastman, GAN268RJHudson David A · Jonesboro, ARN268RVRegistered aircraftN268SStrohmeyer Charles R II · Lancaster, OHN268TCline David R · Maryville, TNN26907Registered aircraftN2690QSilva Alberto · Titusville, FLN26913Alto Vista Flying Club · Cupertino, CAN26915Doolittle Dean M · Bandera, TXN26917Nebrig Kenneth J Trustee · Prescott, AZN2691JObrien Terence · Bonney Lake, WAN2691MHartmaier Robert S Jr · Monroe Township, NJ
Back to AD 90-04-06 R1