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.
N4654ZHanson Donald K · Tampa, FLN46550Taylor Timothy A · Justin, TXN46551Strandberg James S · Anchorage, AKN46552Cache Rentals 401k P S P LLC · Greeley, CON46553Colonial Air Inc · New Bedford, MAN46556Bbh Aviation LLC · Peachtree City, GAN4655HWest Bend Air Inc · West Bend, WIN4655JCody Martell Racing Inc · Fort Myers, FLN4655RFroeschl Christopher J · Roanoke, VAN4655WAeroflyin Corp · Miramar, FLN46567Hullquist Claude G · Ringgold, GAN4656JPeters David E · Sylvania, OHN4656RSheremeta David T · Beverly Hills, FLN4656VWest Riverbend LLC · Washington, MON46570Nied Rossana C · Duarte, CAN46574Martz G Rodney · Frederick, MDN4657GFlorida Flight Training Center Inc · Venice, FLN4657JHummel Aileen J · Fort Worth, TXN4657QSaddle Mountain LLC · Cave Creek, AZN4657ZShort Michael J · Independence, ORN46581Gatlin Jason B · Athens, ALN46584Rizzo Joseph V · Binghamton, NYN46586Hardin Thomas E · Bardstown, KYN4658BOwens Flight Training LLC · Lafayette, LAN4658RRegistration Pending · Sand Springs, OKRegistration pendingN4658WRehberg Michael C · Albuquerque, NMN46590Registered aircraftN46593Grupo Cuaahtemoc LLC · Canutillo, TXN4659G4659g LLC · Wheeling, ILN4659HSale Reported · Lake Stevens, WASale reported, pending cancellationN4659QN4659q Corp · Papillion, NEN4659RSchmitt Michael T · Danville, ILN465ACBlue Super D LLC · Clark, NJN465CLuluvg LLC · Kalispell, MTN465CAAtp Aircraft 4 LLC · Wilmington, DEN465CJAllegro Christopher J · Simi Valley, CAN465CMUniversity Of Central Missouri · Warrensburg, MON465FARondeau Inc · East Norriton, PAN465JBBrannen John M II · Morris, ILN465NQueen Air Aviation Inc · Belleview, FLN46601Skywarrior Flight Training Inc · Pensacola, FLFirst renewal noticeN4660GAdvantage Aviation Inc · Palo Alto, CAN4660ROgren William E · Red Wing, MNN4660YManess Gary D · Eagle River, AKN46612Dugger Joey D · Nine Mile Falls, WAN46613Mad Cap Inc · Smithfield, RIN46615Lindsay William G · Santa Paula, CAFirst renewal noticeN46616Koubsky Richard L · Hollywood, SCN4661BGalovich David J · Roselle, ILN4661QLaguna Verde Leasing Inc · Wilmington, DE
Back to AD 90-04-06 R1