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.
N4889Albert Lea Arpt Inc · Albert Lea, MNN48895Mulvania Rodney A · Linn, MON4889DPink Skies Inc · Willoughby, OHN4889GKittitas Aero Inc · Kittitas, WAN4889LWerner Joseph H · Wauconda, ILN4889TS&P Aviation LLC · Albuquerque, NMN488BLBlue Line Aviation LLC · Smithfield, NCN488CMEmery Kenneth Russell Jr · Odessa, FLN488DJDelta Juliet Holco I LLC · Ocoee, FLN488EKingdom Air Corps · Sutton, AKN488JWKagey David M · Seabrook, TXN488LGErnst Donald E · North Pole, AKN488MSlaughter Jan K · South Padre Island, TXN488MEEfinance LLC · Wichita, KSN488MTTisler Mark R · Bemidji, MNN488RDWhitnell Mark A · Lehigh Acres, FLN488RRMenke Rex A · Medical Lake, WAN488SKKurt Steven T · Solon, IAN488TCKoch Gregory S · Long Beach, MSN488TWFreeman Jack C · Dumas, ARN488XHahn Jesse J · Cedar Rapids, IAN489Snyder Ralph J · Colorado Springs, CON48900Smtm Holdings Inc · Wilmington, DEN4890PSale Reported · Willow, AKSale reportedN4890UUniversity Of Oklahoma · Norman, OKN48918Aero Fliers LLC · Kalispell, MTN4891JHarris Aircraft Leasing Co · Oklahoma City, OKN4891LToga LLC · Dayton, VAN4891TRoss Stephen C · Santa Fe, NMN48924Cobb Susie O · Fayetteville, TNN4892TTwo Tango Aviation LLC · Plant City, FLN48932Poursartip Nader · Hayward, CAN48935Chambers Wyatt Allan · Ludlow, MAN48938International Flying Club Inc · Winfield, ILN4893ELjl & D Inc · Wilmington, DEN4893GBoldflight LLC · Greenwood, INN4893JMartineau Aircraft Inc · Butte, MTN48941Somboonsap Patanapong · Fort Lauderdale, FLN4894AHagenston Arthur J · Fairbanks, AKN4894EPlyler Aviation Lp · Sherman, TXN4894LPeairs Gregory Ross · Sacramento, CAN4895AHigh Exposure Inc · Wilmington, DEN4895GWilson Forest B · Hollister, CAN4895VEbrite Richard P · Long Beach, MSN48961Sunrise Aviation Inc · Ormond Beach, FLN48966Kapellair LLC · Wickenburg, AZN48967N48967 LLC · Mount Pleasant, SCN4896GGecha Richard Mike · Florence, VTN4896LMike Delta Kilo LLC · Bentonville, ARN4896MSmtm Holdings Inc · Wilmington, DE
Back to AD 90-04-06 R1