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.
N4831TPower Flow Systems Inc · Daytona Beach, FLN4832ESenn David L · Oak Ridge, TNN48333Central Texas College · Killeen, TXN4833LAdbm LLC · Oldsmar, FLN4833TDodson International Parts Inc · Rantoul, KSN48340Candace A Larned Enterprises Inc · Long Beach, CAN4834ANicoletti Will · Eagle River, WIN4834ESweeney Michael J · Seattle, WAN4834LBell Hubert D · Lewiston, IDN4834ZRoesner David A · Salina, KSN48353Clifton Joshua M · Marion, INN4835GFiedler Aviation LLC · Suffolk, VAN4835LSims Kyle Z · Locust Grove, GAN4835TPero Thomas E · Richland, MIN48361Love Roger F · East Grand Forks, MNN48365Ching Robert · Elsie, MIN4836ASales Joe Haney · Seminole, TXN4836GEvolo Aviation LLC · Worthington, OHN4836LPeterson Wayne · Dexter, MNN4836ZDewolfe III Everett C · Cumby, TXN4837FWesellairplanes Com Inc · Wilmington, DEN4837LNavarro Ricky L · Riverview, FLN4838Fajardo Mark A · Longmont, CON4838BAerolina Inc · Hendersonville, NCN4838FThomason Booker T Jr · Chicago, ILN4838LSandstrom David E · Anchorage, AKN4839GPaw Lifter Aero LLC · Madison, INN4839LStandard David W · Toccoa, GAN4839WPiscoya Thomas G · Anchorage, AKN4839ZMacias-Flores Guadalupe · Garden City, KSN483ACTessos Air Service Inc · Wilmington, DEN483EAviation Trust Co LLC Trustee · Oklahoma City, OKN483FLOliver Zachary J · Seligman, AZN483RVCoverstone Timothy L · Bellemont, AZN483SPScandinavian Aviation Academy Inc · El Cajon, CAN483YClassic Air Inc · Paso Robles, CAN48400Vector-USA LLC · Olive Branch, MSN4840LIrons Eric P · Enoch, UTN48410Azar Suzanne S · El Paso, TXN4841DDoorglobe Inc · San Francisco, CAN4841FVidhun Raghuraman R · Southbury, CTN4841LPapa India Echo Inc · Chambersburg, PAN4842AHill Steven Douglas · Stoneville, NCN4842THampsten Jacob Clay · Mesquite, NVN4843Burke Timothy E · Temple, TXN4843ANous Air LLC · Yukon, OKN4843BMaddox Emily Brown · Rosharon, TXN4843EMoody Jerry W · Olympia, WAN4843THuizenga Jamie L · Pierre, SDN4843ZLeno Stuart J · San Antonio, TX
Back to AD 90-04-06 R1