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.
N48MMDierks Herman D · Round Rock, TXN48MRCasey Mike P · Whitefish, MTN48PKWoodward Daniel S · Springville, UTN48PRBadrow Allan R · Warrenton, VAN48RDMiller Montgomery A · Carmel, INN48RJJennings Frederick T · Friona, TXN48RPClark Mitchell J · Parker, CON48SSiragusa Pamela L · Cypress, TXN48SJJohnston Stephen P · Hawley, MNN48SUGriffith Aviation Inc · Griffith, INN48TDFoster Aviation LLC · Missoula, MTN48WLAtkinson Matthew D · Theodore, ALN49004Oakland Flyers LLC · Oakland, CAN49005Sunrise Aviation Inc · Ormond Beach, FLN4900CRider Bradley H · Juneau, AKN4900HNew Horizon Aviation Inc · Warwick, RIN4900JUniversal Technical Institute Inc · Avondale, AZN4900LJonghan Park · Stanton, CAN4900URegistration Pending · Rockville, MDRegistration pendingN4900ZPeden Max S · Eagleville, TNN4901MSchaller Lee · New Athens, ILN4901ZUnger Michael D · Bellingham, WAN49024B2fh Ltd · Allentown, NJN49025Central Virginia Aviation Inc · North Dinwiddie, VAN4902FFlying Vikings Inc · Hayward, CAN4902LObrien William M · Aptos, CAN49039Welcome Aviation LLC · Hayward, CAN4903LPlane Crazy Aviation LLC · Hollywood, SCN49043Edwards Pacific Aviation Corp · Dover, DEN4904GC & W Aviation LLC · Trumbull, CTN4904JLunken Air Group LLC · Cincinnati, OHN4904LSchmick David D · Sturgis, MIN49055Lima Aviation LLC · Lake Havasu City, AZN4905JMoore Albert III · Las Vegas, NVN49060Skylogix Aircraft LLC · La Habra, CAN4906JSeal Air LLC · San Juan Capo, CAN4906LRitter Steven L · Harlingen, TXN4906MUnivair Aircraft Corp · Aurora, CON4906TSmith Bruce · Leonardtown, MDN49070Ilmberger Stephen Joseph · San Leandro, CAN49075Mccullough Nancy D · Abilene, TXN49079Alexander Joseph · Hamilton, INN4907JHarmon Neil A · North Chelmsford, MAN4907LSmooth Landin Inc · Melville, NYN4907TPhoenix East Aviation LLC · Daytona Beach, FLN4907ZChristie Ian A H · Limon, CON4908JHolm R Stan · College Place, WAN4908PJohnson Dalton S · Sterling, AKN49090Victory Aviation LLC · Winchester, VAN49094Fleck Richard N Trustee · Camarillo, CA
Back to AD 90-04-06 R1