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.
N79351Dust Devils Aviation LLC · Richland, WAN79358Henderson Steven R · Madison, WIN79359Schultz Steven R · Tea, SDN7935CRfc Inc · Hiawatha, IAN7935NTorrington Flying Club Inc · Torrington, WYN7935PBarnett Michael DBA · The Woodlands, TXN7935WRather Be Flying LLC · New Castle, DEN79360Lewis Robert T · Avondale, AZN79361Narayan Systems LLC · Dayton, OHN79362Esfandiari Ozra · Las Vegas, NVN79363Holmes Shaun B · Georgetown, TXN79365Durden Bobby D Jr · Statesboro, GAN79368Jmr Investments LLC · San Antonio, TXN7936GWatson Carlton D · Campbellsville, KYN7936PHawkins Robert J · Lamesa, TXN7936WHiller Jeron P · Marshfield, WIN79374Johnson Stephen C · Columbus, OHN79378Janoski David Michael · Fort Worth, TXN7937WYang Zhongyi Deroll · Oro Valley, AZN79380Marr Steven K · Saint Charles, MON79382Hood Gary L · New Caney, TXN79383De Michele Fabio Jose Delgado · Pembroke Pines, FLN79387Luckenbach Adam W · Friendswood, TXN79388Mulligan Lawrence · Murray Hill, NJN7938CVolar Corp · El Cajon, CAN7938GDelaney Patrick James · Marion, TXN7938MSanders David D · Alvin, TXN7938PWardly George A · Ridgewood, NJN7938WPiper Club LLC · Atkinson, NEN7938YEai Aircraft LLC · Fairbury, NEN79390Grass Louis Humberto III · Hanford, CAN79391Scott William H · Mount Pleasant, SCN79393Frandsen Travis · Rexburg, IDN79395Cj Aviation LLC · Phoenix, AZN79397Scholl Aaron K · Abbeville, ALN79399Schneider Uwe · Port Orange, FLN7939GMilton Alvah E II · Surrency, GAN7939NOrama Jorge H · Fort Myers, FLN7939PHarper Hill Investments LLC · Independence, LAN7939WCaviation LLC · Columbus, NEN793AMeridian Aircraft LLC · Wilmington, DEN793CAChristiansen Aviation LLC · Wilmington, DEN793LLetourneau University · Longview, TXN793NDUnd Aerospace Foundation · Grand Forks, NDN793PTCappe Investment Group LLC · Homestead, FLN793SPLeading Edge Aviation Inc · Doylestown, PAN793YPark City Flight Training LLC · Merrill, WIN7940EAircraft Guaranty Corp Trustee · Oklahoma City, OKN7940NCloudburst Resources Inc · Lavonia, GAN7940WMurray Air LLC · Patoka, IL
Back to AD 90-04-06 R1