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.
N739WRRaritan Valley Flying School · Princeton, NJN739WXAce Of Spades Aviation LLC · Las Vegas, NVN739WYN739wy LLC · Cheyenne, WYN739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeN739XA7550g LLC · Birmingham, MIN739XCAllen Danny T · Jonesboro, LAN739XKAirways Aviation Inc · Grand Rapids, MNN739XLFlyrjf LLC · Weirsdale, FLN739XMEnstad Ordell J · Goldendale, WAN739XSGorman Patrick M · Deerfield, OHN739XTS O W Aviation LLC · Crystal River, FLN739XUTraining Mission Aviation Inc · New Tripoli, PAN739XVAmaro Mark S · Mi Wuk Village, CAN739XWWhole Life Wellness Center · Alpine, TXN739YESundance Air Services Inc · Alameda, CAN739YHMelbourne Flight Training LLC · Melbourne, FLN739YMHeritage Aviation LLC · Ankeny, IAN739YRF&O Flight LLC · Calhoun, GAN739YURrrr Aviation LLC · Bryan, TXN739YWPettit Toby B · Morehead, KYN739YZSocal Aviation Inc · Chino, CAN739ZCP&B Aviation LLC · Watkins, CON739ZGR & R Aero Services Llcc · Eden Prairie, MNN739ZHFreeflight Aviation LLC · Allentown, NJN739ZLLefebvre Jeffrey S · Kaneohe, HIN739ZNOur Jett LLC · Englewood, CON739ZPBlue Sky Aviation LLC · Watkins, CON739ZSPryor James A · Bottineau, NDN739ZUMelbourne Flight Training LLC · Melbourne, FLN739ZWHolladay Aviation LLC · Jacksonville, FLN739ZXN739zx Flying Association · Kent, WAN739ZZR & R Aero Services LLC · Eden Prairie, MNN73AGHarrison Albon Wayne Jr · Lake Jackson, TXN73ALHefel Lori A · Wichita, KSN73AXJensen Steven · Port Angeles, WAN73BABob Air Inc · Gastonia, NCN73BCVnk Sky Inc · Dover, DEN73BWBravo Whiskey Holdings LLC · Lewis Center, OHN73CMMau Christine A · Niceville, FLN73CVLiberatore A H Bud · Eagle Point, ORN73DYoseph Barry L · Olympia, WAN73DCTwin Aviation LLC · Liberty Hill, TXN73DXAj Airlift LLC · Arlington, MAN73ECBronisevsky Robert · Old Bridge, NJN73FRWayman Luy LLC · Weston, FLN73FTBerecz Kevin · Parrish, FLN73GBBotsford Glenn J · Cudahy, WIN73GSHill Gregory A · Romeo, MIN73HUFx Consulting Ltd · Washington, OKN73HYDenniston Tom · Sherwood, AR
Back to AD 90-04-06 R1