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.
N6343PMcgowan John B · Sunnyvale, CAN6343QWindsock Aviation LLC · Edmond, OKN6344CPayne Ernest Charles · Dana Point, CAN6344LCheney Dustin S · Phillipsburg, KSN6344NPlane Fun Inc Tr Trustee · Snellville, GAN6344PStanford Scott M · Spring Branch, TXN6344QSoseman Christian James · Maricopa, AZN6344RGalaxy Electronics LLC · Hallandale Beach, FLN63450Skywarrior Flight Training Inc · Pensacola, FLN63456Ace Of Spades Aviation LLC · Las Vegas, NVN6345CKrajewski Jerry J · Elgin, ILN6345JHaywood Ken P · Acworth, GAN6345NColeman Darryl W · Fayetteville, GAN6345QPerry Edward Glen Trustee · Ozark, ARN6345VBas Part Sales LLC · Greeley, CON6346D6d Leasing LLC · Englewood, CON6346JSons Thomas · Norwood, MNN6346NYoung Marlon V · Santa Rosa, CAN6346RBuresh Noah A · Blair, WIN6346VPierobon Luciano I · Port Orange, FLN6346WCottrill William M Jr · Joplin, MOFirst renewal noticeN63470University Of Central Missouri · Warrensburg, MON6347DAnthelion LLC · Flemington, NJN6347JGrove City Aviation LLC · Mercer, PAN6347LMcdonald Brion J · Palo Alto, CAN6347MPavco Inc · Gig Harbor, WAN6347PGear Down Hangar LLC · Phoenix, AZN63482Hess Garrett J · Fullerton, CAN63483Eagle Sky Patrol Inc · Deadwood, SDN6348BXin Han Aviation LLC · Atwater, CAN6348JWingsleasing LLC · Wichita, KSN6348NNelson Spraying Service Inc · Chester, MTN6348PRoddy Shannon B · Walker, LAN6348QMartin Chadwick P · Palm Harbor, FLN6348WMarquette County Flying Club Inc · Marquette, MIN6349Fox Christopher Kirk · Hanover, PAN6349CAmmons Gearey L · Marion, ARN6349DSprinkle Brent · Hillsboro, TXN6349GKuhns Mathew M · Saranac, MIN6349JH & H Aviation Enterprises LLC · Fairfield, OHN6349LFutrell Robert T · Pensacola, FLN6349MTakai Hiroyasu · San Jose, CAN634BWWoodard Brent · Whitefish, MTN634DPErvc Holdings LLC · Bumpass, VAN634FTNew Life Aviation LLC · Greeneville, TNN634LLetourneau University · Longview, TXN634MMWutzke Jon R · Fargo, NDN634RSAugust Aero LLC · Kalispell, MTN634SJAmeriflyers Of Texas Inc · Addison, TXN634TWDanley Arthur A Jr · Port Orange, FL
Back to AD 90-04-06 R1